Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
bhaveshp90
Creator III
Creator III

Show Values with no data

Hello,

I have the bar graph with line axis as shown below.

My X-axis shows 'Value_Bucket' column with the range (<10%, 10-14%, 14-20%, 20-25%, 25-30%, 30-35%, 35-40%, >40%)

My Y axis has the Sales-$ data.

I want to all the Value_bucket ranges, i.e. Values with no data

Capture.PNG

I want to show like below graph (Showing all the bucket range with no data also)

Capture.PNG

Please help me, thanks in advance.

7 Replies
vishsaggi
Champion III
Champion III

Did you try unchecking suppress 0 values in presentation tab?

bhaveshp90
Creator III
Creator III
Author

vishsaggi Thank you for your response.

I tried unchecking the Suppress 0 values, but my sorting condition is violated after doing that.

Capture.PNG

thanks

vishsaggi
Champion III
Champion III

What is that you are expecting to see did you stretch your chart to right? Can you share your sample file if possible?

Anil_Babu_Samineni

I would just to replicate Expression level?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bhaveshp90
Creator III
Creator III
Author

vishsaggi‌, I want to sort the X axis accordingly;

<10%, 10-14%, 14-20%, 20-25%, 25-30%, 30-35%, 35-40%, >40%  in acending order ?


But after I uncheck the Suppress 0 values my expression condition failed. 

bhaveshp90
Creator III
Creator III
Author

Can you explain in detail How to replicate the expression, as I am very new to qlik, thank you.

vishsaggi
Champion III
Champion III

Can you share your file if possible?