Dollar expression with Agg function

lohitala — Mon, 26 Jan 2026 18:19:17 GMT

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.

Re: Dollar expression with Agg function

sunny_talwar — Wed, 04 Jul 2018 23:09:37 GMT

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

topic Re: Dollar expression with Agg function in QlikView

Dollar expression with Agg function

Re: Dollar expression with Agg function