Solved: How to get distinct values for the fields - Page 2 - Qlik Community

Anonymous · ‎2017-10-31

Hi Experts,

How to get distinct values for the fields, i have filed called PROGRESS

Progress -->Completed, In progress, Late, I have Student field

If a student is enrolled into two programs: one is completed and other in progress : count towards IN-PROGRESS only
If a student is enrolled into two programs: one is completed and other in late : count towards LATE only
If a student is enrolled into two programs: one is late and other in progress : count towards IN-PROGRESS only

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

Anonymous · ‎2017-11-02

Hi Sunny,

Thanks for your Quick response . that is working fine for me .

My intention is not to fooling every one but suddenly my req was changes to that.... Sorry for that. now it fine

ThankYou

Regatds

Kk

sunny_talwar · ‎2017-11-02

Then you have to mention that your requirement has changed... how else will I know that things have changed my friend?