topic Re: 2 questions about DATE in QlikView

2 questions about DATE

Mon, 31 Mar 2014 08:59:44 GMT

I have a date filed in my script in the standar form "yyyy-mm-dd"

Q1)

on my sheet I have 2 object:

listbox 1: expression =year(DATA)

listbox 2: expression =month(DATA)

When I choose an year from lisbox1, it clears the selection of month (listbox2), and when I choose a month from lisbox2, it clears the selection of year (listbox1)... so I can't select at the same time a month and a year.. why? I would like to select them at the same time!

Q2)

I have a graph where I want to compare data for the last year and the previous year, so I have 2 expression:

expression1: sum( {<DATE={"=Max(Year(DATE))"}>} measure) WORKS

expression2: sum( {<DATE={"=Max(Year(DATE))-1"}>} measure) DOES NOT WORK

How should I write the second expression?

Thank u very much!!

Riccardo

Re: 2 questions about DATE

MarcoWedel — Mon, 31 Mar 2014 09:02:52 GMT

1: create seperate fields for year and month in the load script:

LOAD

DATA,

year(DATA) as Year,

month(DATA) as Month

FROM YourTable;

2: use this seperate Year filed in your set expressions:

sum( {$<Year={$(=max(Year))}>} measure)

sum( {$<Year={$(=max(Year)-1)}>} measure)

regards

Marco

Re: 2 questions about DATE

its_anandrjs — Mon, 31 Mar 2014 09:05:08 GMT

For 1st check DATA field is same for

listbox 1: expression =year(DATA)

listbox 2: expression =month(DATA)

For 2nd try like

sum( {<DATE={"=Max(Year(DATE)-1)"}>} measure)

Hope this helps

Thanks & Regards

Re: 2 questions about DATE

tresB — Mon, 31 Mar 2014 09:06:18 GMT

Very hard to answer without knowing your application. Try to create a sample app and share here.

expression2: sum( {<DATE={"=Max(Year(DATE))-1"}>} measure) DOES NOT WORK

For this one, DATE={"=Max(Year(DATE))-1"} should probably be(if the earlier example of yours was working) :

DATE={"=Max(Year(DATE)-1)"}

Re: 2 questions about DATE

simondachstr — Mon, 31 Mar 2014 09:09:09 GMT

Q1) As you're making selection in the same field the current selection will override the prior one. I recommend you to create the two different expressions directly in the script and load them as two separate fields.

Q2) Try sum( {<DATE={"$(=Max(Year(DATE))-1)"}>} measure)