topic Re: Pivot or Straight table in QlikView

Pivot or Straight table

mandilicious — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Pivot or Straight table

raman_rastogi — Thu, 27 Sep 2018 12:00:32 GMT

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

Re: Pivot or Straight table

mandilicious — Thu, 27 Sep 2018 12:51:11 GMT

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

Re: Pivot or Straight table

Anil_Babu_Samineni — Thu, 27 Sep 2018 13:04:59 GMT

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)

Re: Pivot or Straight table

raman_rastogi — Thu, 27 Sep 2018 13:11:36 GMT

try this

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

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

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

Thanks

Raman