Need help with expression

[Anonymous]

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]

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]

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]

Exactly.

[Anonymous]

Thanks for your help!!

[Qrishna]

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

Glad i was able to help you.

Krishna