topic Alternate State use in Chart title in QlikView

Alternate State use in Chart title

Mon, 25 Nov 2013 13:23:32 GMT

Hi folks,

I have the attached qvw in which I am using alternate states to find out which customers bought item A and didn't buy item D everything works fine in the chart my qustion depends on the title. I want to have a dynamic title which will contains the results of the selected values in both listboxes e.g. "Customer which bought A and didn't bought D" as you can see the problem is how to get the second value "D".

Any ideas?

Kind Regards,

Helen

Re: Alternate State use in Chart title

daveamz — Mon, 25 Nov 2013 13:29:39 GMT

Hi Eleni,

Check the Help Manual for getfieldselections()

Note!

It is not possible to use chart field functions in conjunction with Alternate States as these functions do not have a set_expression parameter to set the state.

Best regards,

David

Re: Alternate State use in Chart title

tresB — Mon, 25 Nov 2013 13:37:54 GMT

Use:

Only({[Excluded Set]} Item)

PFA

Re: Alternate State use in Chart title

daveamz — Mon, 25 Nov 2013 14:00:54 GMT

If you'll have more than 1 value selected in "Excluded Set"

=Concat({[Excluded Set]} DISTINCT Item,',')

Re: Alternate State use in Chart title

CELAMBARASAN — Mon, 25 Nov 2013 14:10:46 GMT

Hi,

I hope there will be a possibilty to get more than one selected. so you could go with Concat({[Excluded Set]} Distinct Item, ','). Because Only gives the Null is it has morethan one possible/selection in that field.

Re: Alternate State use in Chart title

Mon, 25 Nov 2013 14:23:08 GMT

Thank you all guys, I was stuck to this stupid thing!