Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
d_koti24
Creator II
Creator II

Reg Period Selection

Hi All,

I have a field period,that field contains

Periodsales
9/29/2015100
9/30/2015200
10/01/2015333
10/02/2015444
10/03/2015555
10/04/2015666
10/05/20152222

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

7 Replies
Anonymous
Not applicable

Yesterday you were having same thread??

Anonymous
Not applicable

This was working fine, try it out:


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

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

sujeetsingh
Master III
Master III

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

d_koti24
Creator II
Creator II
Author

But req is different from yesterday

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

Anonymous
Not applicable

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)

d_koti24
Creator II
Creator II
Author

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.

Anonymous
Not applicable

Its giving me same output.

PFA..