Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Giselle100
New Contributor II

Data Display

I have built an app and upon opening the app, no data displays.

These are my expressions:

Variables

vMaxYear=if(getselectedcount(Year)=0, max({<CurrentYear = {1}>}Year),max(Year))

vMinYear=MIN("Year")

Expressions

Refund Units TY = sum({<Year={$(vMaxYear)}>} [Refund Qty])

Refund Units LY = sum({<Year={$(vMaxYear)}-1>} [Refund Qty])

My data goes all the way up to 2021 which does not have data hence the TY has no values as we not there yet.

How do I restrict my data to display where we currently are today?

We also have a field calendar type (which has two calendars planning and financial). How do I restrict the data to display where we currently at in above-mentioned calendars?