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

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

rjyadav94 — Thu, 12 Dec 2024 16:29:32 GMT

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

,#straight table

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

Oleg_Troyansky — Thu, 12 Dec 2024 20:19:44 GMT

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.

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

rjyadav94 — Fri, 13 Dec 2024 08:53:18 GMT

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

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

Kushal_Chawda — Fri, 13 Dec 2024 09:30:32 GMT

@rjyadav94 Your aggr expression seems incorrect. Try below format

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

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

rjyadav94 — Fri, 13 Dec 2024 10:36:57 GMT

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

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

Kushal_Chawda — Fri, 13 Dec 2024 12:26:40 GMT

@rjyadav94 share sample app to look at