Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

chart expression: total keyword and calculated dimension

Hi,

In my chart, I have a calculated dimensions that I would like to not ignore in the expression. There is one other calculated dimension that I would like to ignore. So there two calculated dimensions. I want to ignore want and take the other one in the group by of expression

my expression is something like

sum(total rev)

the expression for the rowbreakdim dimension that  I dont want to ignore is

=$(=if(GetSelectedCount(%SPMRowBreakDownSubOptionAlias)=0, '"'& %SPMRowBreakDownOption & '"', '"'& %SPMRowBreakDownSubOption & '"'))

which I have labled as rowbreakdim and I want it not to be ignored in the expression

Can someone please tell me how to put this whole calculated dimension in the total key word in the chart expression If I have to ignore the other dimension but not this one?

Shah

Labels (1)
0 Replies