topic Re: How to filter data based on hardcoded filter in App Development

How to filter data based on hardcoded filter

tauceef9 — Tue, 27 Feb 2018 07:27:33 GMT

Hello Everyone,

I have a requirement wherein I have to create a Hardcoded filter like below:

ValueList('A','B','C')

And as per the value selected by user in the above filter I have to modify the data of a particular table (not the overall application).

Please suggest if there's any way of doing this.

Qliksense Version: QS Desktop June

Regards,

Tauceef

Re: How to filter data based on hardcoded filter

jaumecf23 — Tue, 27 Feb 2018 08:19:30 GMT

Try something like this:

if(ValueList('A','B','C')='A', formula A',

if(ValueList('A','B','C'))='B', formula B', formula C'))

Re: How to filter data based on hardcoded filter

tauceef9 — Thu, 01 Mar 2018 10:31:38 GMT

Hi Jaume,

Thanks for your response.

I tried this code but it is not working for me. As mentioned earlier we have created the hardcoded filter which is not linked with my data anywhere.

Is there a way we can get the selected value of a particular filter in sense? so that will use it in my formula to do the calculations.

I found one function "GetFieldSelections(dimention)" but this will not work in my case as I have created this filter using Listvalue() function.

Looking forward for a work around.

Edited:

Just found one more thing, which is bad again.

I have created the filter using Valuelist() function but when I select anything, no filter is getting applied.

Now I think I have to start asking from one step backword:

1. how to create a hardcoded filter with some values.

2. how we can use this filter in any chart or table to filter data.

Regards,

Tauceef

Re: How to filter data based on hardcoded filter

jonathandienst — Thu, 01 Mar 2018 10:47:48 GMT

A ValueList() is not a field, and it only has any meaning inside the object in which it is defined. So you can reference the ValueList from a dimension in an expression in the same object, but there is no way to select a value or to retrieve the selected value from another object, a macro or the load script.

It sounds like you need an island table - one that is not associated with any other table. Something like

ValueIsland:

LOAD * Inline

[

island_Value

];

Now use the fields island_Value instead of the ValueList()

Re: How to filter data based on hardcoded filter

tauceef9 — Sat, 03 Mar 2018 03:04:04 GMT

Thanks Jonathan, it works perfectly for me.

Regards,

Tauceef