Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Matthias1
Contributor
Contributor

Fix value

Hi everybody,

 

I'm displaying the following KPIs

- sales of today

-sales of this week 

and a few other things.

However, if I select a specific date of this week (through a filter) it shows me in the KPI 'sales of this week' also only the sales of this one selected day. How can I fix, that the KPI always shows 'sales of this week', no matter what date I choose?


Thank you very much 🙂

3 Replies
Lisa_P
Employee
Employee

Set Analysis is what you need, if you share your expression and fields that may be filtered to change it, someone could modify your KPI expression to so what you need
Channa
Specialist III
Specialist III

try use expression

IF(count(date)>1 then 'Sales of Week','sales of Day')& sum(sales)

Channa
Vegar
MVP
MVP

It would be much easier to answer if you shared the expression with us. However I guess that you will to add a SET modifier into your expression to ignore your selected date value.

If I assume that you already have a SET in your expression then the modifier would only be
YourDateField=

If you don't already have a SET then you would need to add
{< YourDateField= >}

Your final expression would look like this
SUM({< YourDateField= >} yourExpression)