Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm new to Qlikview and I've got a question about the use of fields from an inline load. I want to show a field in a
bar chart, but the chart does not show the right value. It is easier to explain my problem with a short example:
I loaded the fields 'Stock' and 'Cash' in and sorted them in a table 'All fields' using an inline load.
LOAD * INLINE [
All fields
Stock
Cash
];
Now, I want to show the field 'Stock' in a bar chart. I set the dimensions (year, company name), created
a list box with the table 'All fields' and selected 'Stock' in this list box.
The expression of the chart is the problem: it don't know how to get the value of the stock for a certain year and company.
I tried several things:
=if(GetSelectedCount([All fields])>0, sum([All fields]), 'Does not work')
The value I get is 0, while the value should be 50. I checked that [All fields] is equal to 'Stock', so I don't understand
why I don't get the right value.
I also tried sum(GetFieldSelections([All fields])), but it does not work either (and I tried a lot that did not make any sense)
Can anyone help me?
Thanks in advance!
could you post your .qvw ? I'm not sure to well undersatnd your Inline loading....
I do not have a .qvw which I can share so that is why I tried to formulate this example.
But the fields 'Stock' and 'Cash' are fields that I loaded from an Excel file into a .QVD file (which I loaded in Qlikview).
Sorry for being unclear but I hope this makes it more clear.
see if this can help you....
Please find attached to see if this is what you are trying to do. I used the expression:
sum($(=[All fields]))
And also allowed only one selected value for [All fields]
Hope this helps!
This is what I mean, thanks! It did not work completely the same in my .qvw, but the idea is the same.