Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Selecting options from multiple list boxes tied to same field

Hi, I am building a dashboard that has multiple tabs.  In one of the tabs, I'm tracking sales data by product.  In my raw data, I have a field with the date of sale of a particular product.  My data table has only one field for date as of now.

I've created two list boxes based on the date field.  One list box displays the year, and one list box displays the month.  With this setup, if I pick Jun in Listbox#2, I cannot pick 2014 and 2013 in Listbox#1, since both are tied to the date field.  I can either do a selection in the Month listbox or Year listbox, but not both together.  If I need to see only Jun 2014 data, I cant. 

How do I overcome this?  Is there a way to do it, or should I create a separate field for the year and month from the date, and make those my source?  Also, since the data comes from Excel, should I do that calculation in Excel and thereby reduce the load of Qlikview load, or can I do that directly in my Load script without too much overhead?

Thanks much for your guidance.

1 Solution

Accepted Solutions
Highlighted

Hi,

you already found the solution on your own, you have to create seperate month and year fields from your date field during load.

Don't worry about additional load in QV and don't waste any efforts in extending your excel source.

The script extension could look like this:

LOAD date,

     Year(date) as year,

     Month(date) as month

FROM your.xls;

hope this helps

regards

Marco

View solution in original post

3 Replies
Highlighted

Hi,

you already found the solution on your own, you have to create seperate month and year fields from your date field during load.

Don't worry about additional load in QV and don't waste any efforts in extending your excel source.

The script extension could look like this:

LOAD date,

     Year(date) as year,

     Month(date) as month

FROM your.xls;

hope this helps

regards

Marco

View solution in original post

Not applicable

Great. Thanks for clearing that out for me. Can you help me with the

syntax/formula to create a field for quarter and for financial year for

India, where Q1 is from Apr-Jun and Q4 for Jan to Mar of the following

year?

Thanks in advance.

Sent from my SGS3 Android Smartphone

Highlighted

please close this thread if your initial question is answered and open another one for new questions.

thanks

regards

Marco