Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
Anyone know why the following won't return a value in an expression in Qlik Sense?
Avg({<
[Dimension]={'MaxString([Dimension])'}
//[Dimension]= {'Value'}
>}[Measure])
When I try it without the commented section ([Dimension]= {'Value'}) I get the desired result.
I've also tried without the single quotes (Dimension and result of MaxString are non-numeric) with no avail:
Avg({<
[Dimension]={MaxString([Dimension])}
//[Dimension]= {'Value'}
>}[Measure])
Try this:
=Avg({<[Dimension]={"$(=MaxString(Dimension))"}>}[Measure])
That worked, thanks sunindia.
I see I used single quotes instead of double.
No problem
I am glad I was helpful.
Best,
Sunny