Permanent Filter on Sheet

[ROCC]

Hi All

I've searched and failed to find what i am looking for, so hopefully someone can help me here....

I only want to show data on a sheet when a field is of a specific group of values - I want this to persist all the time, so only those values are available to choose from in the list box on the sheet and if a user doesn't select any of those values, the sheet will still be restricted to those values, e.g.

AAA - hide

BBB - show

CCC - show

DDD - hide

EEE - show

User can only ever see BBB, CCC & DDD - and can select one or all of them, but will never see AAA or DDD....

(Not sure if this complicates or helps, but the value in this field is populated  from a separate table - the values AAA and DDD are actually blank, i.e. they didn't match with anything in the 2nd table)

[abhijitnalekar]

Hi @ROCC ,

Is this particular logic for all users or a specific set of users? 

[ROCC]

All users

(I should say, I have only be using QV for a week or so.... so still trying to learn everything from scratch)

[abhijitnalekar]

Hi @ROCC ,

We can't do this for the whole sheet but yes, we can apply the condition on the component used in the sheet.

You can do as follows. 

You can see the below-highlighted condition for every chart write below condition in it

match(fieldname,'BBB','CCC','EEE'>=1)

[ROCC]

Thanks - i think i have made a mistake posting this in Qliksense forum, whilst I am in QV... however, i was able to use this in the QV table and it worked, allbeit created an additional column... 

If youre familiar with QV and know how to do it a different way so it persists across the sheet, that would be great.

[abhijitnalekar]

Hi @ROCC ,

You can write the same condition in Qlikview also under chart property--> General Tab