topic In Chart Expression If, Aggr,Concat - Not working in QlikView

In Chart Expression If, Aggr,Concat - Not working

Lavanya — Sat, 16 Nov 2024 02:15:02 GMT

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

Re: In Chart Expression If, Aggr,Concat - Not working

Arthur_Fong — Fri, 11 Oct 2019 08:05:45 GMT

There you go:

Refer qvw attached for detailed logic at script level.

Thanks and regards,

Arthur Fong

Re: In Chart Expression If, Aggr,Concat - Not working

Lavanya — Fri, 11 Oct 2019 08:41:39 GMT

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

Re: In Chart Expression If, Aggr,Concat - Not working

Arthur_Fong — Fri, 11 Oct 2019 08:46:08 GMT

Remove the rest of the dimensions expect Country will do:

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

Re: In Chart Expression If, Aggr,Concat - Not working

sunny_talwar — Fri, 11 Oct 2019 12:15:22 GMT

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)

Re: In Chart Expression If, Aggr,Concat - Not working

Brett_Bleess — Tue, 15 Oct 2019 15:49:48 GMT

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