Discussion board where members can get started with QlikView.
I have a straight table with:
Dimension: Expression Expression
CLIENTS Total Revenues Revenues only with Salesgroup A
Currently because I have an expression for Total Revenues, I'm getting the full list of clients in the dimension.
I'd like to list only CLIENTS which have revenues with Salesgroup A.
Is there a way to do this with set analysis in the Dimension?
Thanks in advance!
Go to Solution.
You can use a calculated dimension. Something like:
Change Salesgroup, Revenue and CLIENTS to the names of your fields.
Enable the option Suppress When Value Is Null for the calculated dimension.
Can You please provide Sample Data.