Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
alexcill
New Contributor III

Re: Filter

The calculated listbox only returns one value (teh total variance). Maybe I didn't undestood correctly your solution...

alexcill
New Contributor III

Re: Filter

That's what I mentiones, it seems to work, but if you click the first decreased sales:

Ej1.png

You get this:

Ej2.png

And there are other decreased sales... Even if you change the expression using original references (not column(1), Column(2), etc.) it doesn't work properly...

Highlighted
alexcill
New Contributor III

Re: Filter

I've included

LOAD * INLINE [

'Variance'

'New sales'

'Lost sales'

'Increased sales'

'Decreased sales'

];

in order to create a list I understand I can't use to manage a variable to apply a filter, but I still can't find the way to apply filters...

Highlighted
alexcill
New Contributor III

Re: Filter

Is there any action linked to a button I could explore/use??

Highlighted
alexcill
New Contributor III

Re: Filter

Select field seems to be an option, but what if it's an expression, not a field?

Highlighted
madhumitha
Contributor

Re: Filter

Seems like its very tough to do Alex. I will keep trying your requirement and post if I could get through.

Highlighted
alexcill
New Contributor III

Re: Filter

I made it reviewing the calculated dimension. It seems that I made a mistake. Thanks for your help.