topic Re: Reg Period Selection in QlikView

Reg Period Selection

d_koti24 — Wed, 04 Nov 2015 08:23:44 GMT

Hi All,

I have a field period,that field contains

Period	sales
9/29/2015	100
9/30/2015	200
10/01/2015	333
10/02/2015	444
10/03/2015	555
10/04/2015	666
10/05/2015	2222

Ex:

if i select 10/05/2015 i want data in bar up to latest month dates like 10/01/2015,10/02/2015,10/03/2015,10/04/2015,10/05/2015

if i select 10/02/2015 i want only 10/01/2015,10/02/2015

if i select 10/01/2015 i want only 10/01/2015 bar.

how to achieve this ?

Thanks

Koti

Re: Reg Period Selection

Anonymous — Wed, 04 Nov 2015 08:26:58 GMT

Yesterday you were having same thread??

Re: Reg Period Selection

Anonymous — Wed, 04 Nov 2015 08:34:10 GMT

This was working fine, try it out:

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

=sum({<Period={'<=$(=VMaxPeriod)'}>}Sales)

Re: Reg Period Selection

sujeetsingh — Wed, 04 Nov 2015 08:39:23 GMT

You can assign a variable and use it like. Well like there be a variable

vSelectedDate= getFieldselected(Period) -------- this will be in date format and will contain the selected period.

Now use dimesion limit in your bar chart and set values less than.vSelectedDate

Re: Reg Period Selection

d_koti24 — Wed, 04 Nov 2015 10:01:39 GMT

But req is different from yesterday

here exp should find current month and dimension values in the chart should current selection month dates only.

Re: Reg Period Selection

Anonymous — Wed, 04 Nov 2015 10:09:43 GMT

For me, what you have mentioned is same what you did yesterday.

NP, try as earlier shared with you:

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

=sum({<Period={'<=$(=VMaxPeriod)'}>}Sales)

Re: Reg Period Selection

d_koti24 — Wed, 04 Nov 2015 10:21:58 GMT

thanks for response balraj ,

but its not working properly

i need only current selection month dates in bar chart

ex : if i select 10/5/2015

i want onlt dates from 10/01/2015 to 10/05/2015.

2) if i select 10/03/2015

i want only dates from 10/01/2015 to 10/03/2015

3) if i select 10/01/2015

i want only 10/01/2015.

Re: Reg Period Selection

Anonymous — Wed, 04 Nov 2015 10:55:26 GMT

Its giving me same output.

PFA..