topic Re: Show values dimension when the measure is zero in App Development

Show values dimension when the measure is zero

Shi — Sat, 16 Nov 2024 00:40:32 GMT

Hi to everyone!

I have an issue.

I have a Measure= 'Volumes', a dimension MONTH and VALUE. In a TABLE CHART I want to show values for MONTH dimension only when sum of Volumes =0

I tried the following expression, but it seems that Qlik sense doesn't show rows when the measure it's equal to zero.

if (aggr (Sum ({$ <Measure = {'Volumes'}>} VALUE), MONTH) =0, MONTH)

I tried already the option Include zero values in the data handling, but it doesn't work.

Thanks a lot!

PriyankaShivhare — Sat, 06 Feb 2021 15:07:24 GMT

if(sum(volumes)=0,Value,sum(Volumes))
may be u can put ur requirement as current table set and expected table set.

Anil_Babu_Samineni — Sat, 06 Feb 2021 15:55:00 GMT

Try this

Dimension : MONTH

Expression : Sum({<MONTH={"=Sum(Volumes)=0"}>} Volumes) OR

Sum({<MONTH={"=Len(Sum(Volumes))=0"}>} Volumes)