Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

sandeepj13
New Contributor III

How to apply "Cr" "Lacs" logic to null values.

Hi,

The below logic for showing values in Cr, Lacs and Abs is not getting applied for Null values. Because of which when we select "Cr" the pie chart shows the null values as the highest share and rest value as minuscule.

Num(

sum([Order Value])

/

if(Currency='Cr',10000000,

if(Currency='L',100000,

1))

,'#,##0.00'&if(Currency='Cr',' Cr',

if(Currency='L',' L'))

)

Regards,

Sandeep Joglekar

1 Reply
agni_gold
Valued Contributor

Re: How to apply "Cr" "Lacs" logic to null values.

So what you want instead of null ,

In this condition , you should first check ISNULL condition then your expression ,

Send sample file , it will easy to help you.