topic Development in App Development

Development

badamsrinivas — Thu, 14 Apr 2022 18:52:55 GMT

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

MayilVahanan — Fri, 15 Apr 2022 00:50:32 GMT

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);

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

badamsrinivas — Sat, 16 Apr 2022 05:56:06 GMT

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 — Sat, 16 Apr 2022 07:07:39 GMT

Try like below

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

Chart or KPI will give past and current year info.