Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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?