Dynamic data changes in Qlik Sense

[#1]

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.

[swuehl]

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;

[#3]

Hi Swuehl,

I have data ready, Please let me know how to create drop down list to select the year and graph change accordingly.

[swuehl]

Have you tried with a filter pane object?

[reddy-s]

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