topic Re: Converting Expression value to Dimension in Straight table in QlikView

Converting Expression value to Dimension in Straight table

mkiran_18 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

This is my expression in straight table:

=Only({<[Product Code] = P({$} [Product Code] )>*State_1<[Product Category]={'Sports'}>} [Product Group]

How to convert the same as dimension instead of expression?

Thanks in Advance.

vishsaggi — Sat, 06 Oct 2018 14:37:02 GMT

Try this in your calculated dimension:

= Aggr(Only({<[Product Code] = P({$} [Product Code] )>*State_1<[Product Category]={'Sports'}>} [Product Group]),[Product Group])

mkiran_18 — Sat, 06 Oct 2018 15:29:06 GMT

Hi Vishwarath,

Thanks, its working.