Discussion board where members can get started with Qlik Sense.
I have a table where I count The sum of quantity using variables ( min and max quantity, min and max visit)
I use this formula
((Sum(Quantity) >= $(MinVisit) and Sum(Transaction) < $(MaxVisit)) and (Sum(Quantity) >= $(MinQuantity) and Sum(Quantity) < $(MaxQuantity)))
, Quantity )
I want to calculate the mode of quantity--- mode(Quantity) but when I use the variables it should change appropriately
Are you checking both MinVisit variable against Sum(Quantity) or should that be Sum(Transaction)??
what exactly do you mean by this? Can you elaborate with an example?
"I want to calculate the mode of quantity--- mode(Quantity) but when I use the variables it should change appropriately"
This is Formula where I Calculate Sum Quantity and now I want to calculate Mode of this Quantity. Using same variables Than I used calculating sum of Quantities.and How can I calculate mode of Quantity restricted with this variables?
I am not sure I understand... would you be able to share some sample data and explain the output you are looking to get?
Hi, I'm not sure to understand, if you change Sum to Mode it doesn't works?