topic Re: Straight Table Value in Text Object in QlikView

Straight Table Value in Text Object

NewToQV — Wed, 25 Nov 2020 16:16:04 GMT

I have a straight table with multiple expressions which show values from an excel table that is loaded.

Is it possible to load values from these 'table cells' if you will into a text object.

e.g. I want the values in Column 2 ([Product]), row 1([Card 1]) to show as the text in a text object so on and so forth. How would I make this occur?

Re: Straight Table Value in Text Object

Anil_Babu_Samineni — Wed, 27 Feb 2019 02:17:59 GMT

Try this?
Firstsortedvalue(product, -aggr(sum(card), product))

Re: Straight Table Value in Text Object

NewToQV — Wed, 27 Feb 2019 16:43:04 GMT

Thank you @Anil_Babu_Samineni .

What if I want to pull values in the following rows? The goal is still the same, pull various values from "Cells" into text objects. e.g. Column 1, row 2 into text object a, column 1, row 3 into text object b, column 1 row 3 into text object c, so on and so forth.

Note that I have 4 dimensions. Would I need to specify all 4 in order to call the value from the correct row?

Dimensions are as follows:

1. As of Date

2. Partnership

3. Partnership Product

4. Min/Max

My other columns and values are being brought in through expressions. e.g. = Age (which is a column name from my staged data file in excel)

Re: Straight Table Value in Text Object

NewToQV — Tue, 05 Mar 2019 15:23:45 GMT

Anyone else? What are my options here? I'm lost.