Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
sidneylu
Creator III
Creator III

Need help with expression

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

5 Replies
krishna_2644
Specialist III
Specialist III

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

sidneylu
Creator III
Creator III

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

krishna_2644
Specialist III
Specialist III

Exactly.

sidneylu
Creator III
Creator III

Thanks for your help!!

krishna_2644
Specialist III
Specialist III

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

Glad i was able to help you.

Krishna