topic Re: Passing expression in aggr in QlikView

Passing expression in aggr

smilingjohn — Thu, 23 Jun 2022 06:17:51 GMT

Hi All,

Basically I am trying to show a column in pivot table with color indication as 'G' and 'R' to do so I am using below calculated formula . and this formula works good for me .

Aggr(If(PTG=PT,'G','R'),Product)

But I am stuck in including a expression within the above calculated logic . Count({<sev-={'5'}>}ID)

I am attaching my file if you look at the color table it shows 'R' actually it should 'G' .

Thanks

Thanks in Advance

Re: Passing expression in aggr

smilingjohn — Thu, 23 Jun 2022 13:39:15 GMT

Hi Expertise any help on my above post

Thanks

Re: Passing expression in aggr

smilingjohn — Fri, 24 Jun 2022 17:16:47 GMT

Hi All,

I tried everything that I can but this is not helping

Waiting for some suggestions from any one

Re: Passing expression in aggr

smilingjohn — Sat, 25 Jun 2022 18:32:35 GMT

Still waiting for some luck.....

Re: Passing expression in aggr

smilingjohn — Tue, 28 Jun 2022 16:58:37 GMT

No Luck for me .....