Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
maniram23
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
Anil_Babu_Samineni

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

Hi Mani,

The Output data is sample or original value??

maniram23
Creator II
Creator II
Author

Hi Dinesh,

that is original value.