topic Re: Calculated Dimension and Only(), Total not working in QlikView

Calculated Dimension and Only(), Total not working

Heena — Sat, 16 Nov 2024 02:29:14 GMT

Hi All,

I have data as below: and App is attached, PFB.

Details_table:

Employee,   Subject,    Status
aaa,                 English,     Completed
aaa,                 Hindi,         OverDue
aaa,                Marathi,      NotOverDue
aaa,                French,       NotRequired
xyz,                 Math,           NotOverDue
cde,                Science,      Completed
nmo,              Bangla,        OverDue
nmo,              English,       Completed

Description for : Status Consideration/calculation in UI

Status is categorized as into two categories, Completed & NotCompleted.

(Employee whose Subject status is Completed is Completed, and no need of calculated% to show in UI/Chart

Employee whose Subject status is Overdue, NotOverdue come under NotCompleted, % to show

Employee whose Subject status is NotRequired is not considered at all. )

Completed=Completed, NotCompleted= 'Overdue', 'NotOverDue'

% for NotCompleted= Employee with status Overdue,NotOverDue/Employee with status Complete,Overdue,NotOverDue

Expected Output is:

Employee| Status| %

cde|Completed|

nmo|NotCompleted|50%

aaa|NotCompleted|66%

xyz|NotCompleted|100%

Thanks In Advance! Help is appreciated 🙂

Thanks & Regards,

Heena Kauser

Re: Calculated Dimension and Only(), Total not working

StarinieriG — Fri, 13 Sep 2019 12:14:16 GMT

try to see file attached

Re: Calculated Dimension and Only(), Total not working

tresB — Fri, 13 Sep 2019 12:14:20 GMT

Try:

=Aggr(If(Count({<Status={'Completed'}>}Status)=Count(Status), 'Completed', 'Not Completed'),Employee)

Re: Calculated Dimension and Only(), Total not working

sunny_talwar — Fri, 13 Sep 2019 12:18:25 GMT

The 'Details' chart in your expression was incorrectly using the field name as status instead of Status.. changing that, changed the output of the table

Knowing this, do you change the expected output, or would you still want to see 0 for cde?

Re: Calculated Dimension and Only(), Total not working

Heena — Mon, 16 Sep 2019 07:38:15 GMT

Hi Sunny,

By mistake I might have used the field name as status instead of Status. Sorry,My Bad!

The requirement remains the same.

Thanks & Regards,

Heena Kauser

Re: Calculated Dimension and Only(), Total not working

Heena — Mon, 16 Sep 2019 08:07:05 GMT

Hi,

If I filter on the completed records in Status, NotCompleted records are also visible.

Only Completed should be visible.

Thanks & Regards,

Heena Kauser

Re: Calculated Dimension and Only(), Total not working

sunny_talwar — Mon, 16 Sep 2019 10:54:49 GMT

So, cde completed should be 0? Why?