topic Re: Create a filter with Variables in QlikView

Create a filter with Variables

Kohli — Sat, 16 Nov 2024 21:54:11 GMT

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.

Re: Create a filter with Variables

renuka_sasikumar — Wed, 14 Nov 2018 05:32:55 GMT

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

Re: Create a filter with Variables

Vegar — Fri, 07 Dec 2018 04:57:10 GMT

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)