Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to see only 2 years of data out of 10 years in qlik dashboards?
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;
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;
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??
Hi
Try like below
=Sum({<Year={">=$(=Year(Today()-1))"}>}urexpression)
Chart or KPI will give past and current year info.