topic Qlik Sense Set expression in App Development

Qlik Sense Set expression

vpanchuda — Thu, 13 Jun 2019 12:23:42 GMT

Hi Can any experts help me with below data.

I need the set expression to count the number of A1,A2, and A3 and group it.

Condition

if Attendance is 'NO, and Grade is 'A1' and if date id blank count 1

if Attendance is 'NO, and Grade is 'A2' and if date id blank count 1

if Attendance is 'NO, and Grade is 'A3' and if date id blank count 1

Grade	Attendance	Date
A1	NO	01-02-2019
A2	NO	___
A3	NO	02-02-2019
A1	NO	___
A2	NO	04-02-2019
A3	NO	05-02-2019

Re: Qlik Sense Set expression

sunny_talwar — Thu, 13 Jun 2019 12:26:39 GMT

So, based on this sample... you would want to see a count of 2?

Re: Qlik Sense Set expression

vpanchuda — Thu, 13 Jun 2019 12:31:29 GMT

Hi Sunny

It should count only if there is a corresponding date.(i think my question is confusing)

Grade	Attendance	Date
A1	NO	01-02-2019
A2	NO	___
A3	NO	02-02-2019
A1	NO	___
A2	NO	04-02-2019
A3	NO	05-02-2019

My result table should be something line below.(it should not count if there is no date)

A1	1
A2	1
A3	2

Re: Qlik Sense Set expression

sunny_talwar — Thu, 13 Jun 2019 12:35:18 GMT

This should work where Grade is a dimension

Count({<Attendance = {'No'}, Date = {"*"}>} Grade)

Re: Qlik Sense Set expression

vpanchuda — Thu, 13 Jun 2019 12:45:39 GMT

Hi Sunny Used -={""} and worked , only problem is if I show it in a Pivot the null values Shows (-) , is there any way to make it 0 instead?

Re: Qlik Sense Set expression

sunny_talwar — Thu, 13 Jun 2019 12:49:42 GMT

May be uncheck 'Suppress Zero-Values'

Re: Qlik Sense Set expression

vpanchuda — Thu, 13 Jun 2019 12:58:16 GMT

I am not able to find this option in Pivot table in Qlik Sense

Re: Qlik Sense Set expression

sunny_talwar — Thu, 13 Jun 2019 13:01:05 GMT

My bad, I was under the impression that you might be using QlikView... anyways I am not really sure what you have, would you be able to share a sample qvf to show the issue?