Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

I want to ignore a date field but set expression is wrong?

Hi

I have a sales funnel dashboard setup that shows funnel value based on all kinds of variables like sales stage, product, date.

I want to show a sales order YTD (in millions) value in the same sheet and I can get this using a simple KPI with this formula:

sum([Order Value])/1000000

My problem is that as soon as change a variable like status or product or date, the value goes to ZERO.

Surely I don't have to ignore all of the other field one-by-one?

Is there a way to tell the dashboard to keep the Sum([Order value]) constant, even if I change variables from the other data source?

Kind regards

Oliver

Tags (1)
1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: I want to ignore a date field but set expression is wrong?

2 Replies
sunny_talwar
Not applicable

Re: I want to ignore a date field but set expression is wrong?

Clever_Anjos
Not applicable

Re: I want to ignore a date field but set expression is wrong?

Basically use "1" as modifier plus "P" to use the dimensions you need

sum({1<Dim1=P(Dim1)>}[Order Value])/1000000