Development

[badamsrinivas]

how to see only 2 years of data out of 10 years in qlik dashboards?

[MayilVahanan · Accepted solution]

Hi 

If you want to restrict the data in script part.

Create the calendar for 2 years. 

And in the fact table , you can use exists() function. 

Load * from factTable where exists(Date);

or

Load * from factTable where Year(Date)>=Year(Today())-2;

[badamsrinivas]

Tq somuch for prompt reply,

1 more Query, if i would like to restrict same 2years data at front end(dashboard) level , what expression or function do i need to use??

[MayilVahanan]

Hi

Try like below

=Sum({<Year={">=$(=Year(Today()-1))"}>}urexpression)

Chart or KPI will give past and current year info.