Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. 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)
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.