topic Selecting options from multiple list boxes tied to same field in QlikView

Selecting options from multiple list boxes tied to same field

Sat, 18 Oct 2014 20:29:23 GMT

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.

Re: Selecting options from multiple list boxes tied to same field

MarcoWedel — Sat, 18 Oct 2014 23:10:36 GMT

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

Re: Selecting options from multiple list boxes tied to same field

Sun, 19 Oct 2014 04:58:15 GMT

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

Re: Selecting options from multiple list boxes tied to same field

MarcoWedel — Sun, 19 Oct 2014 07:17:50 GMT

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

thanks

regards

Marco