topic Re: Set Analysis Text Table Chart in QlikView

Set Analysis Text Table Chart

Fri, 09 Sep 2011 10:17:36 GMT

Hi,

currently i facing following problem:

I have a table chart where Text should be displayed but different from the current selection. Thats why I thaught this works with using Set Analysis.

The problem is that i do not have any clue which funciton I can use for Text. Sum of course gives me always NULL.

I also tried with Text() but there i can not use set analysis.

Remarks.ShortDescription is text.

regards,

corleone

sum( {$<Remarks.Date=, Remarks.State={*}-{'closed'}>} Remarks.ShortDescription)

Re: Set Analysis Text Table Chart

IAMDV — Fri, 09 Sep 2011 10:21:27 GMT

Hi Corleone,

Have you tried use Only() Function?

Only( {$<Remarks.Date=, Remarks.State={*}-{'closed'}>} Remarks.ShortDescription)

Because, we don't want to perform aggregation on the field. If this doesn't work, then please can you post the sample QV document and I can work on the expression.

Cheers - DV

Re: Set Analysis Text Table Chart

gandalfgray — Fri, 09 Sep 2011 10:25:06 GMT

Try any of these:

MinString( expression )

MaxString(expression )

FirstValue(expression)

LastValue(expression)

hth/gg

Set Analysis Text Table Chart

Fri, 09 Sep 2011 11:12:42 GMT

Thanks DV for the fast support! perfect!

Re: Set Analysis Text Table Chart

IAMDV — Fri, 09 Sep 2011 11:59:55 GMT

Corleone - You are welcome. I am glad it worked for you.

Cheers - DV