topic How to display different values(calc by different formula) in cells ? in QlikView

How to display different values(calc by different formula) in cells ?

Fri, 10 Jan 2014 18:02:34 GMT

Hi,

My Question is how to display the following inline table information in a tabular format.

AnTab:

LOAD * INLINE [

F1, F2

Actuals1, sum(Population)

Actuals2, sum(Revenue)

];

Basically I am evaluating the F2 value for every cell using expression

Thank you

Re: How to display different values(calc by different formula) in cells ?

Gysbert_Wassenaar — Fri, 10 Jan 2014 18:42:48 GMT

I'm not sure what you're trying to do. But Qlikview is not a spreadsheet application like MS-Excel. Cells are a key MS-Excel concept. Cells don't exist in Qlikview. At least not in any way you can use for calculations.

Re: How to display different values(calc by different formula) in cells ?

whiteline — Fri, 10 Jan 2014 19:09:10 GMT

Hi.

Hope I understand you right.

Create dimensions that you need and also add F1 as dimension.

Then use

=pick(match(F1, $(=chr(39) & Concat(total F1, chr(39)&chr(44)&chr(39)) & chr(39))), $(=Concat(total F2, chr(44))))

as expression.