Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
@Hi I have a requirement to create a Bar chart in Qlik Sense. I need to Show number of Projects variance where the Variance is Greater than 0.
Is it correct if I write in the Expression as
if(Sum(A)-Sum(B)>0, Sum(A)-Sum(B)).
If I write this Expression I am also getting the projects where the Variance is 0.
Please help me in the regard.
Thanks
Hari
In Add-Ons Section, uncheck show zero value property
Thanks for the reply Shraddha. I have tried that one also but still showing the Records with 0 Values.
Thanks
Hari
Hi Hari,
Council Shraddha should have operated (see attached file). Вы можете разместить здесь небольшой фрагмент данных, а лучше файл QVF с загруженного фрагмента данных?
Regards,
Andrey
what is the number format you are using?
I am using Money format.
Hi Andrey,
I am not seeing any attachment.
Can you share sample app?