Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qliksense

bymonth.gif

In the above graph, when I click on June, graph should show June along with the previous months (Jan-June). Can someone tell me how this can be done?

Thanks

1 Solution

Accepted Solutions
danansell42
Creator III
Creator III

Hi

Please find attached app with revised data

If this resolves your query please mark as correct and/or helpful

Thanks

Dan

View solution in original post

12 Replies
MK9885
Master II
Master II

If June is selected then previous 6 months including June? And if May is selected same 6 months including May?

And if Jul is selected then next 6 months including Jul?

Is that what you want? And is June a static value for you which doesn't need to be changed?

aarkay29
Specialist
Specialist

try using something like this in your exp

sum({<[Invoice Date]={"<=$(=Max([Invoice Date]))"},[Invoice Year]={"$(=Max([Invoice Year]))"},[Invoice Month]=>}Sales)

danansell42
Creator III
Creator III

If the months are in a proper date format (dual) then below will work to give a year to date selection graph

Sum({<Month = {'<=$(=Max(Month))'} >}Tornadoes)

ahaahaaha
Partner - Master
Partner - Master

Hi Aishwarya,

Perhaps in the attached file is idea what you need, if I understand you correctly.

Regards,

Andrey

Anonymous
Not applicable
Author

Hi,

Normally in Qliksense when a particular bar on a graph is selected, it gets drilled down. But what instead of drill down is the previous months to appear.

Example: When I click on June, all the bars from Jan till June should appear.

Can this be achieved?

danansell42
Creator III
Creator III

Hi

Is this what is required?

Capture.PNG

Anonymous
Not applicable
Author

Yes. This is what I was looking for.

danansell42
Creator III
Creator III

I'm glad it resolves your problem.

Please mark as correct to close of the discussion

Anonymous
Not applicable
Author

Just another query.

Can this be achieved when I click on the bar (June) on the graph or it mandatorily requires 'Month' filter pane?

Thanks

Also,

Am I missing something?