Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

girishrainbow
New Contributor II

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
vishalpujari22
New Contributor III

Re: i want only some ROWS from 1 dimension in filter

Hi ,

may be like this

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

5 Replies
vishalpujari22
New Contributor III

Re: i want only some ROWS from 1 dimension in filter

Hi ,

may be like this

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

vishalpujari22
New Contributor III

Re: i want only some ROWS from 1 dimension in filter

Listbox->Expression

girishrainbow
New Contributor II

Re: i want only some ROWS from 1 dimension in filter

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

vishalpujari22
New Contributor III

Re: i want only some ROWS from 1 dimension in filter

Sorry?

girishrainbow
New Contributor II

Re: i want only some ROWS from 1 dimension in filter

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