Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

dgiannicola
New Contributor II

KPI Edit expression

Hi, I'm Daniele. I need to edit code for a KPI graph in expression mode to count data if diff field 1 is > field 2. Can you help me ?

Tx.

Daniele

8 Replies
MVP & Luminary
MVP & Luminary

Re: KPI Edit expression

if diff field 1 is > field 2.

What is diff field 1? The difference between field 1 and something else?


talk is cheap, supply exceeds demand
dgiannicola
New Contributor II

Re: KPI Edit expression

Hi Gysbert, if fild1 subtraction field2 > 2, count number.

In edit expression field1 and 2 are column.

Can you help me ?

tx

Daniele

MVP & Luminary
MVP & Luminary

Re: KPI Edit expression

Maybe like this Count(If(field1-field2>2,number)). Make sure to use the exact case sensitive field names that exist in your Qlik Sense app.


talk is cheap, supply exceeds demand
dgiannicola
New Contributor II

Re: KPI Edit expression

Hi Gybert, it works! Thank you so much!.

Do you know if exist a manual for develop language in edit expression ?

Really tx.

Daniele

MVP & Luminary
MVP & Luminary

Re: KPI Edit expression

A manual.. no, not really. There's the online help and there are a number of books. Those books focus on Qlikview, but the syntax for expressions is the same in Qlik Sense. The two best books are Qlikview 11 for Developers and Qlikview your business.


talk is cheap, supply exceeds demand
Highlighted
dgiannicola
New Contributor II

Re: KPI Edit expression

Hi Gybert, between operator in edit express also hard.

I need to translate this query in edit expressio form:

select Incident from INCIDENTS where date >1 and date <2

Can you help me ?

Tx.

Daniele

MVP & Luminary
MVP & Luminary

Re: KPI Edit expression

=If(date > 1 and date < 2, Incident)


talk is cheap, supply exceeds demand
dgiannicola
New Contributor II

Re: KPI Edit expression

Hi Gysbert, it work!

Tx

Daniele