Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am new to Qlikview and Qlik sense, I have data from 2009 to 2015 for pre and post July.
When the user clicks on 2009 Pre July line graph is creating.
How to create drop down menu for
2009 pre july
2009 post july
2010 pre july
2010 post july etc
When the user click on a year the line chart has to change dynamically.
Please provide ideas on this data visualization.
Thanks In advance.
If I understand correctly, you want an additional field linked to your existing Year and Month fields, to group the data in pre post July classes. Create this field in the load script, then use a list box to select your values:
LOAD Year,
Month,
if(Month < 7, Year & ' pre july', Year & ' post july') as Season
FROM YourDataSource;
Hi Swuehl,
I have data ready, Please let me know how to create drop down list to select the year and graph change accordingly.
Have you tried with a filter pane object?
Hi Ashalatha,
I would suggest you to go through a series of video here : New to Qlik Sense Videos
This will give you a very good insight on what exactly Qliksense does and its capability. There are umpteen number of documents in the Qlik Sense Resource Library which will help you understand most of the technical aspects of it.
Hope this Helps!
- Sangram