Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
Contributor

Use Calculated Dimension to restrict the date

Hi All,

My Data is 

ValueDateRegon
18/31/2018N
19/30/2018S
110/31/2018N
011/30/2018S
112/31/2018N
01/31/2019S
12/28/2019N
03/31/2019S
14/30/2019N
05/31/2019S

 

Expected output in pivot table. My requirement is to restrict the Date  for last 2 dates using the calculated dimension  . Please suggest

 RegionNS
 Date4/30/20195/31/20194/30/20195/31/2019
Value 1000

 

Thanks in advance.

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Use Calculated Dimension to restrict the date

Hi,

maybe use something like this

=Aggr(If(Rank(Date)<=2,Date),Date)

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: Use Calculated Dimension to restrict the date

Hi,

maybe use something like this

=Aggr(If(Rank(Date)<=2,Date),Date)

View solution in original post