topic Re: Show Date dimension even when no value present in QlikView

Show Date dimension even when no value present

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

Hi guys,

Trying to create a bar graph to show performance over last 12 months.

Result is correct when no selection is made

But when I make a selection on the currency, Month with zero values disappear.

How do I make it that zero values appear even if I make a selection?

Cheers.

Re: Show Date dimension even when no value present

ahammadshafi — Mon, 19 Mar 2018 04:10:18 GMT

Hi Kim:

You can check the box with "Show All Values" for the dimension.

-- Shafi

Re: Show Date dimension even when no value present

k_burata — Mon, 19 Mar 2018 04:58:36 GMT

Hi Ahammad,

Did that and it did showed all but what if I want to limit it to the last 12 months like what I did on the expressions tab?

=num(SUM({<[Date] = {">=$(v12MonthStart) <=$(v12MonthEnd)"}>}[Value]), '$#,##0.##')

Cheers

Re: Show Date dimension even when no value present

ashwinishinde — Mon, 19 Mar 2018 05:36:28 GMT

Dear Concern,

Try This,

Re: Show Date dimension even when no value present

shiveshsingh — Mon, 19 Mar 2018 06:00:40 GMT

Try this, hope this helps.

Re: Show Date dimension even when no value present

k_burata — Mon, 19 Mar 2018 06:18:17 GMT

Hi Shivesh,

I would want to show the last 12 months. Is there a way to do this?

Regards,

Re: Show Date dimension even when no value present

k_burata — Mon, 19 Mar 2018 06:20:08 GMT

Hi Ashwini,

This would work if I did not select a Currency. Once I select a value from currency this does not work anymore.

Regards,

Re: Show Date dimension even when no value present

jyothish8807 — Mon, 19 Mar 2018 06:27:50 GMT

Hi Kim,

Try the sample attached.

I have simple updated your variable for my reference, you can revert them.

I have created a new filed called as counter , which have value 1.

Then created a new expression and disable the chart type.

Br,

Re: Show Date dimension even when no value present

k_burata — Mon, 19 Mar 2018 07:26:30 GMT

Hi KC,

Thanks for this. But what if I only want to display 12 months of data only? Like for the past 12 months?

Regards,

Re: Show Date dimension even when no value present

jyothish8807 — Mon, 19 Mar 2018 08:18:08 GMT

Same logic, just change your variables as it was earlier.

I just modified it for my reference

Re: Show Date dimension even when no value present

jyothish8807 — Mon, 19 Mar 2018 08:21:50 GMT

try this:

Re: Show Date dimension even when no value present

stabben23 — Mon, 19 Mar 2018 08:38:58 GMT

this could be a work around, add this *avg({1<[Date] = {">=$(v12MonthStart) <=$(v12MonthEnd)"}>}1)

and Your Expression will be

=num(SUM({<[Date] = {">=$(v12MonthStart) <=$(v12MonthEnd)"}>}[Value]), '$#,##0.##')*avg({1<[Date] = {">=$(v12MonthStart) <=$(v12MonthEnd)"}>}1)

Re: Show Date dimension even when no value present

k_burata — Tue, 20 Mar 2018 01:30:17 GMT

Thanks mate. Solved my problem.

Re: Show Date dimension even when no value present

jyothish8807 — Tue, 20 Mar 2018 07:15:04 GMT

You are welcome