Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis exp for selected year,month and upto selected day

Hello,

I am trying to evaluate set analysis exp for selected  year ,month and upto selected day

i.e(if i select  may 2012 16 then yera=2012 ,month=05 , day= 1to 16)

i tried like this

=sum({<Yearp = {'$(Year)'} ,Monthp = {'$(Month)'} , Dayp = {' >=01   <=$(max(Day))'} >} Qty)

but not working pls  anybody can correct it for me.

Thank U.

5 Replies
jagan
Partner - Champion III
Partner - Champion III

Hi Pankaj,

Try like this, if you have a dimension

=sum({<DateDimension= {'<=$(=Date(Max(DateDimension)))'} , Yearp=, Monthp = , Dayp = >} Qty)

Note : Check the date formats are same in (=Date(Max(DateDimension))) and in DateDimension

Hope this helps you.

Regards,

Jagan.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Is your selection made in a single Date field or three separate fields?

-Rob

Not applicable
Author

Hello sir,

Actually I have created master calender & linked with Posting-date  .

I am selecting calender's year ,Month & day by this posting-date automatically get filtered and Qty also bcoz both are linked with each other .

if i select calender  May 2012 16 then  posting-date is "05/16/2012" and Qty = 984 for 05/16/2012.

Qty also filtered but i want qty from 1 day of month to till date.

so  what u suggest sir.

Thank u

Not applicable
Author

Hi

Please try this.

=num(SUM( {<[FinMonth] = {"<=$(max(FinMonth))"},

[FinQuarterNum] = {"<=$(max(FinQuarterNum))"},

[FinYear] = {"<=$(Max(FinYear))"}>} QTy) ,' #,##0 '),

Regards,

Usman

jagan
Partner - Champion III
Partner - Champion III


Hi,

Try this

=sum({<DateDimension= {'<=$(=Date(Max(DateDimension)))'} , Dayp = >} Qty)

Regards,

Jagan.