I need to create a flag metric in qliksense front (set analysis). This metric needs to mark with 1 when it detects a change in prices and 0 if its the same. The agregation (the line to wactch) is Laboratory, Product, Presentation. These are not in the same table but are related to each other in a "relation" table
Having this data:
Product A, Pres. A, Price 300 (Flag must be 0)
Product A, Pres. A, Price 350 (Flag must be 1)
Product A, pres. A, Price 250 (Flag must be 1)
Product A, pres. A, Price 250 (Flag must be 0) an so on...
The chart im going to create is something like this:
Product |Times it change | Last date of change
A | 2 | 27/10/2023
THANKS!!!!
I got your question that you were looking for a frontend solution. If you don't want to or can't change your data model you could do this:
Create data
Then in frontend, create a table with two measures:
Times it changed
Last Date of Change
Which will give you this result: