Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Pivot Table

Hi experts,

I am trying to do in pivot table as i am not getting the exact output,

my logic is TAT should be" >7 " and the value should be carry forward.

Please check the attached file  1. Sheet 1- Input

                                                  2. Sheet 2 - Output (Required)


3 Replies

May be try like below

1) Pivot table

2) Dim - R/O Date and Center

3) Measure

4) Drag column to Row on top of chart for Center. you will get it

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator II
Creator II

Hi Mani,

The Output data is sample or original value??

Creator II
Creator II

Hi Dinesh,

that is original value.