topic Field value treated like expression in QlikView

Field value treated like expression

blednyi — Thu, 03 Sep 2009 17:20:40 GMT

Hi !

I'm trying to do chart where expression is read in certain field. Why I am trying to do so:

I need pivot table where in different rows have different expression in same column... like you can do in spreadsheet. I know that variable could treated like expression, but I do not want create lots of variables.

I have tried many different ways to solve problem, one expression in above:




=GetFieldSelections

(sarake1)

And selected value in the field is: sum(myynti)

... really basic expression... but QV is treated field value like string

so how can I change string to expression ?

Any Ideas?

or is this too weird way to solve problem [:P]

Field value treated like expression

prieper — Thu, 03 Sep 2009 17:29:25 GMT

Hi,

can you post an example? Might be worth to look at the original data.

Peter

Field value treated like expression

blednyi — Thu, 03 Sep 2009 19:32:04 GMT

Here is example what I'm doing..

and find solution when using text-object, how to handle field value to expression:

=
$(=Column1Calc)

But in pivot table I'm not getting solutions[:'(]

Field value treated like expression

johnw — Fri, 04 Sep 2009 02:31:31 GMT

I must not be understanding what you want, as the pivot table is picking up the same expression as the text object in both 8.5 and 9.0.

Field value treated like expression

Oleg_Troyansky — Fri, 04 Sep 2009 03:37:36 GMT

your logic works just fine, except for the fact that multiple values are available for expressions 2 and 3. If you ensure that only a single value is available at all times, all the expressions will work correctly. You can also use function only(), to ensure that you only want the single available value.

Oleg