topic Re: Show Values with no data in QlikView

Show Values with no data

bhaveshp90 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 02 Jul 2018 20:43:09 GMT

Did you try unchecking suppress 0 values in presentation tab?

bhaveshp90 — Mon, 02 Jul 2018 21:14:22 GMT

vishsaggi Thank you for your response.

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

thanks

vishsaggi — Mon, 02 Jul 2018 23:52:11 GMT

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 — Tue, 03 Jul 2018 05:07:17 GMT

I would just to replicate Expression level?

bhaveshp90 — Tue, 03 Jul 2018 12:37:34 GMT

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 — Tue, 03 Jul 2018 12:38:36 GMT

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

vishsaggi — Tue, 03 Jul 2018 16:11:33 GMT

Can you share your file if possible?