In Chart Expression If, Aggr,Concat - Not working

[Lavanya]

Hi All,

I am very new to QlikView, please help me in the below requirement.

I have data as mentioned below, also app is attached.

Thanks in Advance. Help is appreciated 🙂

Thanks and Regards,

Lavanya

[Arthur_Fong]

There you go:

Refer qvw attached for detailed logic at script level.

Thanks and regards,

Arthur Fong 

[Lavanya]

Hi ,

All the scenarios will have to give the total count without applying filter.

I see the qvw file which I had attached. Could you please check the QVW app.

Thanks

[Arthur_Fong]

Remove the rest of the dimensions expect Country will do:

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

[sunny_talwar]

If you don't want to make changes in the script, you can try these three expressions

Count_Completed
Count(DISTINCT {<Employee = {"=Count(Subject) = Count({<Completion = {'Completed'}>}Subject)"}>} Employee)


Count_OverDue
Count(DISTINCT {<Employee = {"=Count({<Completion = {'OverDue'}>}Subject) >= 1"}>} Employee)


Count_NotOverDue
Count(DISTINCT {<Employee = {"=Count(Subject) = Count({<Completion = {'Not Over Due'}>}Subject) or (Count({<Completion = {'Not Over Due'}>}Subject) >= 1 and Count(Subject) = Count({<Completion = {'Not Over Due', 'Completed'}>}Subject))"}>} Employee)

[Brett_Bleess]

Lavanya, did any of the posts here help you get things resolved?  If so, please do not forget to use the Accept as Solution button on those posts that did help, so others will know which one(s) worked and to also give credit to those posting those.  If you did something different, consider posting that and then mark it, and if you are still needing further help, post a new update to the thread.

Regards,
Brett