Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Please find attached app with revised data
If this resolves your query please mark as correct and/or helpful
Thanks
Dan
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?
try using something like this in your exp
sum({<[Invoice Date]={"<=$(=Max([Invoice Date]))"},[Invoice Year]={"$(=Max([Invoice Year]))"},[Invoice Month]=>}Sales)
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)
Hi Aishwarya,
Perhaps in the attached file is idea what you need, if I understand you correctly.
Regards,
Andrey
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?
Hi
Is this what is required?
Yes. This is what I was looking for.
I'm glad it resolves your problem.
Please mark as correct to close of the discussion
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?