Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
lohitala
Contributor
Contributor

Dollar expression with Agg function

Hi all could you please help me with the expression my expected result in 22 for that dimension.

if(

count(aggr(if((num(count( {<TopBox={'1'},FiscalYear={'2018'}>}SRID)/count( {<FiscalYear={'2018'}>}SRID),'#.00000'))=percent1,Srnumber1),FACILITY,percent1,Srnumber1,QuestionLabel))>1

,min(aggr(if((num(count( {<TopBox={'1'},FiscalYear={'2018'}>}SRID)/count( {<FiscalYear={'2018'}>}SRID),'#.00000'))=percent1,Srnumber1),FACILITY,percent1,Srnumber1,QuestionLabel))

,count(aggr(if((num(count( {<TopBox={'1'},FiscalYear={'2018'}>}SRID)/count( {<FiscalYear={'2018'}>}SRID),'#.00000'))>=percent1,QuestionLabel),FACILITY,percent1,Srnumber1,QuestionLabel))

)

When i am adding the Dollar Expansion in Aggr Expression.

if(

count(aggr(if($(=num(count( {<TopBox={'1'},FiscalYear={'2018'}>}SRID)/count( {<FiscalYear={'2018'}>}SRID),'#.00000'))=percent1,Srnumber1),FACILITY,percent1,Srnumber1,QuestionLabel))>1

,min(aggr(if($(=num(count( {<TopBox={'1'},FiscalYear={'2018'}>}SRID)/count( {<FiscalYear={'2018'}>}SRID),'#.00000'))=percent1,Srnumber1),FACILITY,percent1,Srnumber1,QuestionLabel))

,count(aggr(if($(=num(count( {<TopBox={'1'},FiscalYear={'2018'}>}SRID)/count( {<FiscalYear={'2018'}>}SRID),'#.00000'))>=percent1,QuestionLabel),FACILITY,percent1,Srnumber1,QuestionLabel))

)

And when i am selecting only that Dimension value it displays 22.

Labels (1)
1 Reply
sunny_talwar
MVP
MVP

Would you be able to share a sample to check this out? Difficult to pin-point the issue by just looking at images and expressions