Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
k_burata
Creator
Creator

Show Date dimension even when no value present

Hi guys,

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

Result is correct when no selection is made

Capture.PNG

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

Capture.PNG

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

Cheers.

1 Solution

Accepted Solutions
jyothish8807
Master II
Master II

try this:

Best Regards,
KC

View solution in original post

13 Replies
ahammadshafi
Creator
Creator

Hi Kim:

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

2018-03-19_10-08-09.png

-- Shafi

k_burata
Creator
Creator
Author

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.##')

Capture.PNG

Cheers

ashwinishinde
Partner
Partner

Dear Concern,

Try This,

c2.png

shiveshsingh
Master
Master

Try this, hope this helps.Capture.JPG

k_burata
Creator
Creator
Author

Hi Shivesh,

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

Regards,

k_burata
Creator
Creator
Author

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,

Capture.PNG

jyothish8807
Master II
Master II

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,

KC

Best Regards,
KC
k_burata
Creator
Creator
Author

Hi KC,

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

Capture.PNG

Regards,

jyothish8807
Master II
Master II

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

I just modified it for my reference

Best Regards,
KC