Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
balrajahlawat
Champion
Champion

Yesterday you were having same thread??

balrajahlawat
Champion
Champion

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.

balrajahlawat
Champion
Champion

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.

balrajahlawat
Champion
Champion

Its giving me same output.

PFA..