Qlikconfused

[susovan · Accepted solution]

First all deselect the option of "Supress-Zero-Values" from presentation tab.

 

Then put your requisite condition in below said expression

=if(TRAFFIC_PLACE='FOA',Sum(TOTAL{<Traffic_in={'12'}>}#_NetSales),

Sum(#_NetSales)

)

also find the attached file

[avinashelite]

Could you share the sample qvw files ?

[Anonymous]

Yes it worked!!! Thank you very much!

But there is one more thing. In order to have the correct sum in Net Sales,

i have to choose {ΔΕΛΠ ΔΛΠ ΔΛΠ-TF } from the box TR_KIND or else it brings me wrong numbers.

but for TRAFFIC_PLACE] ='FOA i dont have TR_KIND so when i choose the above the FOA is hidden

So what I have to write in the expression in order to fix it!

STOCK

ΔΕΛΠ

ΔΛΠ

ΔΛΠ-TF

ΠΡΟΚ/ΛΗ

[Anonymous]

Good morning!

Can you plz help me with this?

[susovan]

Try this,

=if(TRAFFIC_PLACE='FOA',Sum(TOTAL{<Traffic_in={'12'},TRAFFIC_PLACE=>}#_NetSales),

Sum(#_NetSales)

)