[Please Help] Problem with Set Analysis and Expression

Wed, 26 Jul 2017 04:23:19 GMT

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);

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()) ]

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.

topic [Please Help] Problem with Set Analysis and Expression in QlikView