topic Re: Expressions with Year, Month, Day selectors in QlikView

Expressions with Year, Month, Day selectors

Sat, 12 Jan 2013 01:25:11 GMT

Hi,

I am new to qlikview and I have to do a job.

I have a graph with a Year, a Month and a Day selector.

if I select year 2012 and months 1 and 2, then days 1 to 19, I would like to sum my data starting from 2012-01-01 to 2012-02-19.

Now my expression sum data of this two ranges: 2012-01-01 to 2012-01-19 and 2012-02-01 to 2012-01-19.

I miss data from 2012-01-20 to 2012-01-31.

Thanks

Sat, 12 Jan 2013 01:55:34 GMT

Hi,

Try this:

sum({$<Year=,Month=,Day=,Date={">=min(Date)<=max(Date)"}>} Data)

If you dont have a Date field, you can create it in the script using: makedate(Year,Month,Day)

Hope this helps

Regards!

Mon, 21 Jan 2013 09:37:19 GMT

Thanks Gabirela, your suggestion has been useful in other expressions, but in this case does not seem to work for me.

On this graph a line is drawn for each year, and the sums are not yet correct.

Perhaps I should also change the main query to include a date field to make comparisons with the dates built with the MakeDate () method.

Thankyou very much.