Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
So, based on this sample... you would want to see a count of 2?
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 |
This should work where Grade is a dimension
Count({<Attendance = {'No'}, Date = {"*"}>} Grade)
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?
May be uncheck 'Suppress Zero-Values'
I am not able to find this option in Pivot table in Qlik Sense
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?