Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

[Please Help] Problem with Set Analysis and Expression

Hi all,

I need your advise about set analysis and expression,

I do a PivotChart like this (This Chart have data on other days too [Mon. Tue,..] but I pick only Friday to ask you);

Untitled2.jpg

Actually I have 10 HUB on Friday but I use 'IF'on top the calculation

to pick up all value that I only interested in by %A [ IF(%A <=-0.1, calculate expression, Null()) ]

and Suppress Zero on Dimension. So It looks quite good now as above.

Then I need new expression to count %A column (Cnt), I use IF again [ IF(%A <=-0.1, 1 , Null()) ]

Untitled3.jpg

But in Total Level was not quite right (have to be 4)

I think that maybe from my IF condition that didn't not SUM just show 1.

So I need to advise with you guys that what should I have to do.

Ps1. It's Pivot Chart.

Ps2. Actually I can count total row by changing chart type to straight table but I need Partial Sum too not only Total SUM.

Thank you,

Pathompong B.

0 Replies