Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
h_prakash
Creator II
Creator II

Qlik Sense Bar Chart - Expression

@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

jaganstalwar1

7 Replies
shraddha_g
Partner - Master III
Partner - Master III

In Add-Ons Section, uncheck show zero value property

h_prakash
Creator II
Creator II
Author

Thanks for the reply Shraddha. I have tried that one also but still showing the Records with 0 Values.

Thanks

Hari

ahaahaaha
Partner - Master
Partner - Master

Hi Hari,

Council Shraddha should have operated (see attached file). Вы можете разместить здесь небольшой фрагмент данных, а лучше файл QVF с загруженного фрагмента данных?

Regards,

Andrey

shraddha_g
Partner - Master III
Partner - Master III

what is the number format you are using?

h_prakash
Creator II
Creator II
Author

I am using Money format.

h_prakash
Creator II
Creator II
Author

Hi Andrey,

I am not seeing any attachment.

shraddha_g
Partner - Master III
Partner - Master III

Can you share sample app?