excluded "Others" in pivot table (Totals)

[Anonymous]

hi,

i only want to see 'Others' value when i have at least one product for my segment.

if i have only "others" for segment i don't want to show that values.

in attach , qvw file and excel for example.

can you help me ?

[Anonymous]

works, now I'm going to reproduce this in Qliksense 

[vinieme12]

you are correct, that will always be necessary when we do a set like this

[Anonymous]

Hi Vineeth,

Could you please explain this set analysis ? I'm not understanding it.

sum({<MarketName = {"=sum(TaskProductType)>0"}>}Quantity)

Sum the quantity where MarketName has the sum of TaskProductType greater than 0.

Is that it?

Thanks,

Sílvia

[vinieme12]

Yes, you've read it correctly

[sunny_talwar]

You can also learn more about this here:

A Primer on Set Analysis