Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Filtering out records in a Table Dimension

Hi

I've a table with two columns. The 1st column is Account name and the 2nd column is account sales.

Accounts have an attribute called account size which has 3 distinct values, Big, Medium and Small.

I've used dimension (not measure) for 1st column to show all the account names.

Is there a way to apply filters on the field Account name (dimension) to display only those accounts that have account size = Big?

Thanks

1 Solution

Accepted Solutions

Re: Filtering out records in a Table Dimension

Try using a calculated dimension

If([Account Size] = 'Big', [Account Name])

2 Replies

Re: Filtering out records in a Table Dimension

Try using a calculated dimension

If([Account Size] = 'Big', [Account Name])

Not applicable

Re: Filtering out records in a Table Dimension

Thanks Sunny. Highly appreciate your help..!

Community Browser