Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.

1 Reply
sunny_talwar

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