Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to map two date values with Master Calendar?

Hi Folks,

I attached the same data.

I want to two filters like Quarter and Week

Based on these two filters, we need to create bar chart

Dimensions:- Month(when i click Quarter it shows on monthly), Week

Measure:- Count(Ticket)

Sub2u444

7 Replies
sunny_talwar

So there are two dates in your sample Ticket 1001 would be plotted on Apr 2014 or Feb 2016?

Not applicable
Author

Open - Apr2014

Close- Feb2016

like above

sunny_talwar

I think you did not understand my question. Let me put it this way. I am guessing that you have MonthYear on your x-axis and would be plotting Count(Tickets) for each MonthYear. Ticket Number 1001 will be plotted on Apr 2014 or Feb 2016?

Not applicable
Author

It was under coming to Jan2016...

If its having OpenDate and there is no CloseDate i.e., under coming to Open

sunny_talwar

This?

Capture.PNG

Not applicable
Author

Above one is correct.

I need to 2 filters i.e., Quarter and Week... i shared the above .. pls check

in the bar chart it was showing some gaps, i don't want that gaps....

Open is looks fine and same for Close i required

this is in QlikSense..Sunny

sunny_talwar

Got it, have a meeting, if no one chips in, I will come back and help