Discussion board where members can get started with Qlik Sense.
Apologies in advance if this is a basic question - but I want to create a KPI on my dashboard to count if products are <, = or > a certain age. The age is setup in my dataset as a calculated field (Date Authorised - Date Logged)
I have filters on the top of the dashboard, so not sure if I can use set analysis? My formula for the KPI is
But the number returned does not correspond with the data in a straight table. Any help/ info on where I'm going wrong much appreciated
Apologies for this - looks like the formula is working but not counting all of the values that is corresponding in the straight table.
KPI is reading 3, but there are 14 samples in the straight table below.
'Age' is a calculated field and I am using =floor(Age) in the straight table as age is timestamped.