Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
georgegv
Contributor II
Contributor II

Aggregation syntax not giving correct data

Hi

I am using the following syntax with aggr function :

aggr(count(PracticeNo),(ScriptPeriod))

It is giving me an partial correct output . It is not filling all the cells on the report.

Attaching screenshot to show output

 

Please help

2 Replies
vmoreno2605
Creator
Creator

I don't know what the expected result is; however, i imagine what you want to do so, try this:

Sum(aggr(count(PracticeNo),(ScriptPeriod)))

 

i hope this helps

georgegv
Contributor II
Contributor II
Author

Hi

 

Thanks however I still get gaps in my data output.

I have attached a screenshot of my output. You will note that blue stars.