Discussion board where members can get started with Qlik Sense.
How to get distinct values for the fields, i have filed called PROGRESS
Progress -->Completed, In progress, Late, I have Student field
How can i achive this?
Name Progress Program
Kiran Complete 1
Kiran In Progress 2
Vijay Complate 1
Anil Inprogress 1
Anill Late 2
kiran should count only for in progress
anil should count for late
vijay should count in Complete
Go to Solution.
May be this
=Sum(Aggr(If(FirstSortedValue(TOTAL <Name> Progress, Number) = Progress, 1, 0), Name, Progress))
Where Number is created in the script like this
Dual(Progress, Match(Progress, 'In Progress', 'Late', 'Complete')) as Number;
LOAD * INLINE [
Name, Progress, Program
Kiran, Complete, 1
Kiran, In Progress, 2
Vijay, Complate, 1
Anil, In Progress, 1
Anil, Late, 2
anil should count in in-progress, right?
yes In progress Only
It didnt worked , I am looking total count of In Progress , Total Count of Complete, Total Count Late seperatly
Separately? What do you mean? You don't want this
Actually if kiran is Complete and also In Progress we have to count kiran in In progress only not Complete
in this case output is
Count of In progress towards student is Complete 1, In progress 1, Late 1
But you didn't you just agree that Anil should be in In Progress bucket also?
That is why Inprogress = 2 and Complete = 1... what is the issue my friend?
Anil Should be in Late Bro.. because Anil is in In Progress and late so he should be in late
The total counts will be like this
In Progress = 1
and If the person is in Complete and Late then it should count only Late
Look at the requirement again
According to c., because Anil is late and in progress, you want it to be counted towards IN-PROGRESS....
And then later you confirmed this also
Look above.... now are you fooling around with me or you don't know what you want?