Create a filter with Variables

[Kohli]

I have KPI with some values  (values in Millions). I want create one filter and when select on filter it shows the drop down  like Lacks, Thousands, Hundred. When select the Lack , KPI value convert into Lacks,  select the Thousand KPI convert into Thousands Etc.  How can i create that variable.

[renuka_sasikumar]

Hi,

First create an Inline Table.

Divider:
LOAD * INLINE [
Denomination, Abbervation_Unit, DenominationValue
Milion, M, 1000000
Thousand, K, 1000
Absolute, , 1
];

Then create one varilable as "vNumDenominator"='=Max(DenominationValue)'

Then use that variable in expression:

SUM(sales)/vNumDenominator.

Hope this help.

Regards,

Renuka S

[Vegar]

In QlikView there is an object type called inputbox . The input box allow you to predefine a list of valid values for your variable and present the variable with an drop down menu for the values.

Expression: Sum(Amount) * $(vVariable)