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

[#1]

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

[Gysbert_Wassenaar]

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.

[whiteline]

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.