topic Re: How to get value of a field from Inline Load in QlikView

How to get value of a field from Inline Load

Tue, 23 Sep 2014 13:21:14 GMT

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!

Re: How to get value of a field from Inline Load

demoustier — Tue, 23 Sep 2014 13:29:50 GMT

could you post your .qvw ? I'm not sure to well undersatnd your Inline loading....

Re: How to get value of a field from Inline Load

Tue, 23 Sep 2014 13:38:12 GMT

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.

Re: How to get value of a field from Inline Load

Tue, 23 Sep 2014 13:41:03 GMT

see if this can help you....

Re: How to get value of a field from Inline Load

jerem1234 — Tue, 23 Sep 2014 13:43:55 GMT

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!

Re: How to get value of a field from Inline Load

Tue, 23 Sep 2014 14:22:04 GMT

This is what I mean, thanks! It did not work completely the same in my .qvw, but the idea is the same.