topic Select value for chart by GetFieldSelections() in QlikView

Select value for chart by GetFieldSelections()

Wed, 08 Aug 2012 12:20:21 GMT

Hi there,

I am quiet new to qlickview hence i got a question..

I have got two items in my sheet

a. Listbox: $Field

b. Chart

The user should be able to select a field in the listbox over which the graph will be calculated.

eg. the listbox contains the values

grand_total

grand_total_net

subtotal

If the user selects grand_total, the graph shows grand_total over time.

I have tried to put in the expression field of the graph the following expression:

SUM(GetFieldSelections($Field))

but it says "No data to display"

Anyone can help? thanks in advance!

Miguel_Angel_Baeyens — Wed, 08 Aug 2012 12:26:57 GMT

Hi,

Try the following instead:

Sum($(=GetFieldSelections($Field)))

Hope that helps.

Miguel

Wed, 08 Aug 2012 12:32:53 GMT

Hi,

Try using variable

DocumentProperties --> Variables --> New --> vTest

In vTest give value = GetFieldSelection($(Field))

In Chart expression take =Sum($(vTest))

May be this helps you.

Thanks & Regards,

Satish.A