topic Need help with expression in QlikView

Need help with expression

Anonymous — Fri, 20 Nov 2020 18:02:30 GMT

Hi,

I'm new to Qlikview.

Can someone explain what this Qlikivew statement mean?

AGGR(COUNT({1 <%KEY_CAT = {"$(=CatSel)"}, %KEY_CLINIC = {"$(=ClinicSel)"} >}[PRID]) ,%KEY_CAT, %KEY_FY)

Thanks

Qrishna — Wed, 04 Nov 2015 17:33:35 GMT

Hi Sydney,

AGGR(COUNT({1 <%KEY_CAT = {"$(=CatSel)"}, %KEY_CLINIC = {"$(=ClinicSel)"} >}[PRID]) ,%KEY_CAT, %KEY_FY)

counting all values in the column [PRID] where %KEY_CAT = {"$(=CatSel)"} and %KEY_CLINIC = {"$(=ClinicSel)"}

and then grouping the counted values with respect to %KEY_CAT, %KEY_FY

hope that helps

Anonymous — Wed, 04 Nov 2015 17:45:15 GMT

Hi Krishna,

Is it the same as this SQL statement?

SELECT

%KEY_CAT,

%KEY_FY,

COUNT(PRID)

FROM XYZ

WHERE %KEY_CAT = {"$(=CatSel)"} and %KEY_CLINIC = {"$(=ClinicSel)"}

GROUP BY %KEY_CAT, %KEY_FY

Qrishna — Wed, 04 Nov 2015 18:19:19 GMT

Exactly.

Anonymous — Wed, 04 Nov 2015 18:59:14 GMT

Thanks for your help!!

Qrishna — Wed, 04 Nov 2015 19:29:19 GMT

Please mark this thread as answered if you got the answer.

Glad i was able to help you.

Krishna