Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Narrowing down a dimension in chart

Hi everyone,

I'm wondering what is the best and most efficient way to write a calculated dimension for the given scenario:

I have rows with account numbers and several other fields in my data. I would like to display in a straight table only those account numbers where [Field 1] = 1, along with every other field in my data associated with those specific account numbers. I have been using this statement: if([Field 1] = 1, [Account Number],), and then writing in every other field as a separate expression. However, I'm not sure if this is the proper way to do it since I'm getting rows that I do not want. Does anybody know of another way to do this? Thanks.

1 Solution

Accepted Solutions

Re: Narrowing down a dimension in chart

Try

Calculated Dimension

if([Field 1] = 1, [Account Number])

Now Select this and tick Suppress When Value is NULL

Keep everything as it is without using the above expression everywhere...

1 Reply

Re: Narrowing down a dimension in chart

Try

Calculated Dimension

if([Field 1] = 1, [Account Number])

Now Select this and tick Suppress When Value is NULL

Keep everything as it is without using the above expression everywhere...

Community Browser