Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kpapanik
Contributor III
Contributor III

Qlikconfused

14 Replies
susovan
Partner
Partner

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

Capture.JPG 

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

Warm Regards,
Susovan
avinashelite

Could you share the sample qvw files ?

kpapanik
Contributor III
Contributor III
Author

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

ΠΡΟΚ/ΛΗ

kpapanik
Contributor III
Contributor III
Author

Good morning!

Can you plz help me with this?

susovan
Partner
Partner

Try this,

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

Sum(#_NetSales)

)

Warm Regards,
Susovan