Discussion Board for collaboration on QlikView Layout & Visualizations.
I am having a Pivot Table with Location,Name & Date as Dimension and Sum of a column Handled as expression.
Output is as given below.
Need to add following columns at teh end.
How do i add this to the Pivot table as last columns post teh dates.
Please provide sample data or sample application. You need to use TOTAL Qualifier to achieve this result.
If Date is also your dimension then i dont think so it is possible to do required thing in Pivot table.
You can try in Straight Table by creating each date value as different Expression.
Please use the above sample data, Ignore location which i will add it later.
How do i change that dynamically.
Today i will have date till JUly 27th and tomorrow it will till 28th.
Do you mean i need to add expression default till 31st always.
Use Straight Table
=SUM(TOTAL <Name> Handled)/COUNT(TOTAL <Name> Date)
Min(TOTAL <Name> Aggr(SUM(Handled),Name,Date))
Max(TOTAL <Name> Aggr(SUM(Handled),Name,Date))
For >= 500
SUM(TOTAL <Name> Aggr(IF(SUM(Handled)>=500,1,0),Name,Date))
In this method for the dates when there is no data available for an Name it takes previous days data and shows the same in Table.
How to avoid it?
Sorry It was my mistake in the expression i had mentioned <=