Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
Try the following instead:
Sum($(=GetFieldSelections($Field)))
Hope that helps.
Miguel
Hi,
Try the following instead:
Sum($(=GetFieldSelections($Field)))
Hope that helps.
Miguel
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