Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
please close this thread if your initial question is answered and open another one for new questions.
thanks
regards
Marco