Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

i want only some ROWS from 1 dimension in filter

Hello,

I have One Column Name Particular

in which I have

ABC,

LKM,

EFG

XYZ,

POC,

etc.

I want only XYZ and LKM to displayed in filter. rest all should not be shown and have effect any where in report.

Can we do such things I don't can not change in dataset as per requirement because others are used in before filters.

Particular
XYZ
LKM
1 Solution

Accepted Solutions
agastya
Creator
Creator

Hi ,

may be like this

=if(Match(Newfield,'XYZ','LKM'),Newfield)

View solution in original post

5 Replies
agastya
Creator
Creator

Hi ,

may be like this

=if(Match(Newfield,'XYZ','LKM'),Newfield)

agastya
Creator
Creator

Listbox->Expression

Anonymous
Not applicable
Author

can I have my name changed like xyz to be named as qwe

agastya
Creator
Creator

Sorry?

Anonymous
Not applicable
Author

As I have Particulars as XYZ but I want QWE lyk giving a alias name