Best way to display the records that form the basis of a calculation...?
Hello all,
In my Qlikview app I have a chart that displays the results to a number of different calculations.
For example, lets say Calculation 1 is
=SUM({<Field1 = {'A'}, Field2 = {'B'}>} Amount)
and this gives me a figure of 10,000
What i want to do is to have a table which lists the sales that make up this 10,000 figure, without having the users needing to filter the data... I have managed to do this (of sorts) by creating a straight table, with a calculated dimension in
Then adding the other fields I wisk to display as normal dimensions
Is this the only way of doing it, is this the best way - is there any way of using Set Analysis to achieve this, from what I understand using lots of IF statements degrades performance significantly...
