topic Re: issue with year selection in QlikView

issue with year selection

ferha_jafri — Tue, 03 Sep 2013 10:10:52 GMT

Hello everyone,

I have an issue as i want to get values such that when i select year the value should get the values from 1-1-of selected year till 3-9-selected year means date of today but year is the selected year . Plz help it is urgent.

Thanks in advance

Ferha Jafri

Re: issue with year selection

rajeshvaswani77 — Tue, 03 Sep 2013 10:15:14 GMT

You can use

yearstart(today()) this will give you 1-1-2013

and today() will give you todays date.

thanks,

Rajesh Vaswani

Re: issue with year selection

ferha_jafri — Tue, 03 Sep 2013 10:20:26 GMT

Rajesh the issue is that i get the sumof sales suppose from 1-jan-of the selected year till today date of the selected year as suppose when i select 2010 then the sum of sales i should get is from 1-jan-2010 to 3-sep-2010.

Re: issue with year selection

Tue, 03 Sep 2013 10:21:16 GMT

Hi,

Try with below script in your UI

sum({<Year={$(vMaxYear)},Date={'<=$(vMaxDate)'},Month=>}Value)

Replace your Year/Date field based on your fields name.

-Jay

Re: issue with year selection

Tue, 03 Sep 2013 10:24:04 GMT

++ Also make sure to Declare the Variables in your Variable Dec part

-Jay

Re: issue with year selection

ferha_jafri — Tue, 03 Sep 2013 10:25:06 GMT

no max of date will get the max date although i want tadays date for the selected year

Re: issue with year selection

Tue, 03 Sep 2013 10:26:18 GMT

Try with:

Start: =YearStart(min(YourDateField))

End: =MakeDate(Year(max(YourDateField)), num(Month(Today())), Day(Today()))

Good luck,

Re: issue with year selection

Gysbert_Wassenaar — Tue, 03 Sep 2013 10:28:05 GMT

Create also a Day field in the script: Day(MyDateFieldHere) as Day. You can then use the Day field in the set analysis expression: sum({<Day={'<=$(=day(today()))'}>}Value)

Re: Re: issue with year selection

Tue, 03 Sep 2013 10:29:47 GMT

Hi,

Refer the attachment. Let me know if I miss anything

-Jay

Re: issue with year selection

er_mohit — Tue, 03 Sep 2013 10:32:27 GMT

try this

Create variable

vstartdate is min(Datefield)

venddate is max(Datefield)

sum({$<Datefield={">=$(=vstartdate)<=$(=venddate)"},Year=,Month=>}Sale)

Re: issue with year selection

Tue, 03 Sep 2013 10:52:33 GMT

Hey, i had to do something similar to analyze this year vs last year on the same period.

=sum( {1< YEAR={$(=(num(Year(TODAY()))))}, PERIOD_NUM= {'>=1<= $(=(num(Month(Today())-1)))'}> }PERIOD_ACTIVITY)

Try to adapt the code to your case adding a set analysis also for day

p.s. Period num is my Month Field