Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Does not calculate in IF-Statement appropriate

Dear all,

I've created an IF-Statement in a chart:

=if([Article Group]='9999',(sum({<[Article Group]={'9999'}>}[Revenues]))+

     (sum(aggr((sum({<[cpa_Main Article Group Description]={'9999'}>}[Revenues])/

     sum({1<[Product]={'A0001'}>}[Revenues])*

     sum({1<[Article Group]={'1111'}>}[Revenues])),[Geography],[Month],[Year])))+

     (sum(aggr((sum({<[cpa_Main Article Group Description]={'9999'}>}[Revenues])/

     sum({1<[Product]={'A0001'}>[Revenues])*

     sum({1<[Article Group]={'2222'}>}[Revenues])*0.5),[cpa_Geo 4],[Geography],[Month],[Year]))),

sum([Revenues]))

My Dimension is Year and Article Group.

If I do not select anything it shows me a different Revenue, than selecting the ArticleGroup in the IF-Statement.

See in this case the gray one: Here it's abount 6Million

without selection.bmp

Once I select, it's about 11M - this is correct.

selection.bmp

But how could I calculate the right one, even without selecting anything?

Thanks for your help.

2 Replies
Not applicable

Does not calculate in IF-Statement appropriate

Seems nobdoy has an answer?

MVP
MVP

Does not calculate in IF-Statement appropriate

I don't see an obvious answer.

Most of the time, it's much easier too find the root causing the issue, if you could post an QV application showing your problem here. If you don't want to post your data here, maybe you could build an example app or load in sample data.

Community Browser