topic Re: aggr help in QlikView

aggr help

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Can any one please help me on below issue.

I have a table like below.

I have filtered 01/18/2017 from due date only that date related System related records i am able to see.

But in the table I have 02/17/2017 and 02/2017 dates also I have. That date related systems not able to see getting null values.

For system dimension I have used

=agg(only({<name={'system'}>}value),issuenum)

Please let me know am i missed any thing in the dimension expression.

Issue due this week measure expressions are like below

=Count(distinct {<DueDate={">=$(=Date(Weekstart(Max(DueDate),0,0),'MM/DD/YYYY'))

<=$(=Date(Weekend(Max(DueDate),0,0),'MM/DD/YYYY'))"},

Status-={'pending'}>}issuenum)

Thanks in advance

sasiparupudi1 — Tue, 03 Apr 2018 10:13:00 GMT

May be

Count(distinct {<DueDate={">=$(=Date(Weekstart(Max(DueDate),0,0),'MM/DD/YYYY'))

<=$(=Date(Weekend(Max(DueDate),0,0),'MM/DD/YYYY'))"},

Status-={'pending'},name={'system'}>}issuenum)

sasiparupudi1 — Tue, 03 Apr 2018 10:13:24 GMT

May be

Count(distinct {<DueDate={">=$(=Date(Weekstart(Max(DueDate),0,0),'MM/DD/YYYY'))

<=$(=Date(Weekend(Max(DueDate),0,0),'MM/DD/YYYY'))"},

Status-={'pending'},name={'system'}>}issuenum)

bhavvibudagam — Tue, 03 Apr 2018 10:28:59 GMT

Hi Sasidhar,

Thanks for your reply.

Actually system is not the direct dimension its derived by name and value fields with below expression.

=agg(only({<name={'system'}>}value),issuenum)

Please help to include this one in the measure expression.

sasiparupudi1 — Tue, 03 Apr 2018 10:34:34 GMT

Count(distinct {<DueDate={">=$(=Date(Weekstart(Max(DueDate),0,0),'MM/DD/YYYY'))

<=$(=Date(Weekend(Max(DueDate),0,0),'MM/DD/YYYY'))"},

Status-={'pending'},value={"=agg(only({<name={'system'}>}value),issuenum)">}issuenum)