Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

In report display NULL in dimension against some specific condition

Hi,
I have a scenario where I need to display Person,City,State, Sales1, Sales2 in a report in QV.

At the Data Model Level, have 3 tables :

1. Person

2. Fact

3. Address

where Address and Person are joined to Fact Table based on AddressKey and PersonKey respectively.

There is a Flag field in the Fact table with Y and N value.

The report should be displayed such that, for all records with Flag=Y in Fact table,

the identity (i.e. Person,City,State) should not be visible(NULL should be displayed) in report while Sales1, Sales2 should be displayed in report.

NOTE : Blank or some other text can also be placed in place of NULL.

e.g

PersonStateFlagSales1Sales2
AabcN100000565222
NULLNULLY200000233556
CxyzN300000225655
NULLNULLY100000122555
NULLNULLY500000122445

Kindly suggest how to implement this.

Thanks in advance !!

Tags (4)
1 Solution

Accepted Solutions
Not applicable

Re: In report display NULL in dimension against some specific condition

Instead of selecting the person as the dimension, try to make a calculated dimension, where you put some code like this:

=if(Flag = 'Y', null(), Person)

2 Replies
Not applicable

Re: In report display NULL in dimension against some specific condition

Instead of selecting the person as the dimension, try to make a calculated dimension, where you put some code like this:

=if(Flag = 'Y', null(), Person)

jvishnuram
Contributor III

Re: In report display NULL in dimension against some specific condition

Hi ng21july,

Hope attcahed file will help you.

Community Browser