topic Re: How to get specific cell values from pivot table in QlikView

How to get specific cell values from pivot table

gf — Sat, 16 Nov 2024 21:08:49 GMT

Hello everyone!

I would like to display specific cell values from a pivot table into a text box.

The cell values are dynamic because you can change the language.

Is there a function/expression like Cells(1,1).Value or something like that?

Thanks in advance!

Re: How to get specific cell values from pivot table

jyothish8807 — Mon, 01 Apr 2019 08:59:43 GMT

Hi Gf,

Not exactly like cell function, but you can use set analysis to get the specific value.

For eg, you want to show the sales of Prodct "A" for month "Feb" in a text box, which is also available in pivot, then write like this in text box:

Sum({<Product ={'A'},Month={'Feb'}>}Sales)

If you can share your exact requirement with some sample data or screenshot, then it will be easy to help you.

Re: How to get specific cell values from pivot table

gf — Thu, 04 Apr 2019 14:41:30 GMT

Thanks for your reply KC!
I'm sorry I'm not allowed to upload the file but i can provide a picture.
Column "1" to "Kontobezeichnung" are dimensions and i need for example the cell value from column 1, row 1. => "A K T I V A"

Re: How to get specific cell values from pivot table

jyothish8807 — Mon, 01 Apr 2019 09:44:03 GMT

Hi Gf,

Since it is a dimension, iam sure there will be a filed you are using in the pivot chart.

So in a text box simply write:

If(YourfieldName='AKTIVA',YourfieldName)

Re: How to get specific cell values from pivot table

gf — Mon, 01 Apr 2019 09:53:32 GMT

But the value AKTIVA can change, for example in english it is written with "C" instead of "K". That's why i want a solution where i don't have to type in "AKTIVA" hard coded. Therefore i need something like Cell(1,1).Value or Top() or Above().....

Re: How to get specific cell values from pivot table

jyothish8807 — Tue, 02 Apr 2019 05:17:17 GMT

Hi Gf,

You can try this:

=subfield(Concat(YourField,','),',',1)

Re: How to get specific cell values from pivot table

gf — Tue, 02 Apr 2019 08:07:59 GMT

Hello KC!

Thanks for the answer! It partly works.

If i type =subfield(Concat(TextG1,','),',',1) i get A K T I V A as expected, but when i try it with =subfield(Concat(TextG1,','),',',2)

I also get A K T I V A.

I thought =subfield(Concat(TextG1,','),',',2) gives my the value from column 1 (=TextG1) cell 2?

Re: How to get specific cell values from pivot table

jyothish8807 — Tue, 02 Apr 2019 08:18:36 GMT

Try this:

subfield(Concat(distinct TextG1,','),',',2)

Re: How to get specific cell values from pivot table

gf — Tue, 02 Apr 2019 08:20:56 GMT

Perfect! Thank you very much!
Thank you for your time and consideration!

Re: How to get specific cell values from pivot table

jyothish8807 — Tue, 02 Apr 2019 08:24:38 GMT

You are welcome