Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Dynamic data changes in Qlik Sense

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.

4 Replies
MVP
MVP

Re: Dynamic data changes in Qlik Sense

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;

Not applicable

Re: Dynamic data changes in Qlik Sense

Hi Swuehl,

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

MVP
MVP

Re: Dynamic data changes in Qlik Sense

Have you tried with a filter pane object?

reddys310
Honored Contributor II

Re: Dynamic data changes in Qlik Sense

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

Community Browser