Discussion Board for collaboration on QlikView Scripting.
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 :
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.
Kindly suggest how to implement this.
Thanks in advance !!
Go to Solution.
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)
Hope attcahed file will help you.