Pivot or Straight table

[mandilicious]

Hi Champs

I need to create report like below:

Details:

I have to type Recorded, Decisions,close,TAT Glass etc. manually. but I do have formulas on how to calculate each details per Month

E.g. Recorded= Count(RecDate) and Current Outstanding-frequence(count(open claims))

The problem is how to display it this way in qlikview?

I cant attach data cause it is big and  has sensitive info.

Thanks

[raman_rastogi]

try this approach

Make a pivot table with Month as dimension and Recored,Decision,close .. etc yours expressions and change your dimension position in pivot table .

Regards

Raman Rastogi

[mandilicious]

Thanks Raman

Quick Questions

1) I need to do set analysis for total to start from Jan to current month like below Above  pic?

2) Is two graphs same calculation but the first graph pulls data where item BU is =MX and second is  where item BU is =Ooba please assist with correct syntax please.

Thanks

[Anil_Babu_Samineni]

This way may give proper result, If format is good

1) I need to do set analysis for total to start from Jan to current month like below Above  pic?

Sum({<Month = {">=$(=Month(YearStart(Today())))<=$(=Month(Today()))"}>} TOTAL Sales)

2) Is two graphs same calculation but the first graph pulls data where item BU is =MX and second is  where item BU is =Ooba please assist with correct syntax please.

     2.1) Sum({<BU = {'MX'}>} Sales)

     2.2) Sum({<BU = {'Ooba'}>} Sales)

[raman_rastogi · Accepted solution]

try this

1-

Sum({<Month = {">=$(=Month(YearStart(Today())))<=$(=Month(Today()))"}>} total sales)

2-

  1- Sum({<BU = {'MX'}>} Sales)

  2-Sum({<BU = {'Ooba'}>} Sales)

Thanks

Raman