Converting of measure expression used in bar chart into dimension in straight table

[rjyadav94]

Hi all

I have a requirement where expression being used in Qliksense bar chart and expression I need to implement as dimension in straight table?

I am attaching the expression in below image with variables included inside the set analysis. 

Immediate response will be appreciated  

•  Qlik Sense Business ,#straight table 

[Oleg_Troyansky]

In order to use aggregated functions in a dimension, you need to enclose it in the AGGR() function, and specify the dimension(s) that you want your function to be aggregated at. The rest should work just fine.

[rjyadav94]

Hi  Oleg,

Thanks for replying. I am using aggr function only but the requirement is like I wanted to show if count>0 then column values should show yes else no.

But in my case it is taking by default as yes 

See the attached expression which I am using 

 

[Kushal_Chawda]

@rjyadav94  Your aggr expression seems incorrect. Try below format

= aggr( if( CountExpression>0 , [MOC Unique ID]) ,[MOC Unique ID])

[rjyadav94]

I tried this also but getting only 1 value as yes in column rest value is null 

[Kushal_Chawda]

@rjyadav94  share sample app to look at