Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.