Show Values with no data

[bhaveshp90]

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

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

Please help me, thanks in advance.

[vishsaggi]

Did you try unchecking suppress 0 values in presentation tab?

[bhaveshp90]

vishsaggi Thank you for your response.

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

thanks

[vishsaggi]

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?

[bhaveshp90]

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]

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

[vishsaggi]

Can you share your file if possible?