Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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)

Regards

3 Replies
Highlighted

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)
Highlighted
Creator II
Creator II

Hi Mani,

The Output data is sample or original value??

Highlighted
Creator II
Creator II

Hi Dinesh,

that is original value.