topic Regarding Period Exp in QlikView

Regarding Period Exp

d_koti24 — Tue, 03 Nov 2015 08:00:38 GMT

Hi ,

i Have field period,

Period	sales
1/30/2015	100
2/27/2015	50
3/31/2015	500
4/25/2015	200
5/29/2015	150
6/01/2015	100
6/02/2015	015
6/05/2015	22
6/06/2015	555
6/08/2015	666
6/10/2015	777

In bar chart i want show the all month end dates with current selection period

ex:

if i select 6/08/2015 in period

i want show bar chart with these values

1/30/2015 2/27/2015 3/31/2015 4/25/2015 5/29/2015 6/08/2015

if i select 6/10/2015 in period

i want show bar chart with these values

1/30/2015 2/27/2015 3/31/2015 4/25/2015 5/29/2015 6/10/2015

how to achive this?

Re: Regarding Period Exp

Mark_Little — Tue, 03 Nov 2015 08:12:30 GMT

Hi,

One possible method would to use a variable.

vSelectedDate

=GetFieldSelections(Period)

Then in your expression use something like below

=SUM({1<Period={"<=$(vSelectedDate)"}>}sales)

Mark

Re: Regarding Period Exp

maleksafa — Tue, 03 Nov 2015 08:24:17 GMT

Hi,

Please check the attached example on your data set. you need to modify the expression and use the possible P() in the set analysis.

Re: Regarding Period Exp

d_koti24 — Tue, 03 Nov 2015 08:30:25 GMT

Hi Malek,

Thanks for quick response...!

but

I want all the month ends in a bar as well as current selection in this month.

Re: Regarding Period Exp

maleksafa — Tue, 03 Nov 2015 09:12:22 GMT

what do you mean by month ends? is it the highest value per month, or you want to accumulate up to the selected date?

Re: Regarding Period Exp

Anonymous — Tue, 03 Nov 2015 09:44:00 GMT

If I am not wrong, you want whatever period you selects, it should give all the data of periods which is less than or equal to your current selection?

Re: Regarding Period Exp

d_koti24 — Tue, 03 Nov 2015 09:50:20 GMT

Highest value of month(.max date )

Re: Regarding Period Exp

sasikanth — Tue, 03 Nov 2015 10:23:31 GMT

HI,

Take Dimension "PERIOD"

write exp like

=sum({<Period={'<=$(= MonthEnd(addmonths( max(Period),-1)))','$(=max(Period))' }>} sales)

Hope it will helps you

Re: Regarding Period Exp

d_koti24 — Tue, 03 Nov 2015 10:30:12 GMT

Hi Sasi ,

can you please attach the sample qvw.

Re: Regarding Period Exp

sasikanth — Tue, 03 Nov 2015 10:34:45 GMT

HI , please find the attachment

Re: Regarding Period Exp

Anonymous — Tue, 03 Nov 2015 10:37:08 GMT

Take a variable:

VMaxPeriod=date(max(PeriodName),'DD/MMM/YYYY')

and then use Expression at chart level:

=sum({<PeriodName={'<=$(=VMaxPeriod)'}>}Amount)

Re: Regarding Period Exp

d_koti24 — Tue, 03 Nov 2015 11:00:58 GMT

Thanks ...!

Re: Regarding Period Exp

d_koti24 — Tue, 03 Nov 2015 12:36:08 GMT

Hi Sasi,

How to do same thing for quarter?

ex:

31/3/2015 10/06/2015

if select 08/06/2015

i want like this:

31/3/2015 08/06/2015.

regards,

koti

Re: Regarding Period Exp

sasikanth — Tue, 03 Nov 2015 13:20:41 GMT

HI,

You can do the same with the above expression

=sum({<Period={'<=$(= MonthEnd(addmonths(max(Period),-3)))>=$(=MonthEnd(addmonths(max(Period),-4)))','$(=max(Period))' }>} sales)

Re: Regarding Period Exp

d_koti24 — Tue, 03 Nov 2015 13:37:32 GMT

Hi Sasi,

Actuvally My period field contains 10months data.

so i want latest 3 quarters last date date and current selection date.

like this :

3/30/2015 6/30/2015 9/30/2015 and current selection date 10/05/2015

How to achive this?

Re: Regarding Period Exp

sasikanth — Tue, 03 Nov 2015 13:48:30 GMT

try something like this

=sum({<Period={'=$(=quarterend(addmonths(max(Period),-3)))','=$(= quarterend(addmonths(max(Period),-6)))','=$(= quarterend(addmonths(max(Period),-9))) ','$(=max(Period))' }>} sales)

but make sure that sales are available for all quarter ending dates