topic Re: Jazzing up a pivot table in QlikView

Jazzing up a pivot table

Daniel_Moore — Mon, 02 Jun 2014 16:09:04 GMT

Trying to make a QVW that looks like this report. I've made a pivot table - see attached QVW but it's a bit lacking... Any suggestions?

Current report:

Re: Jazzing up a pivot table

Anonymous — Mon, 02 Jun 2014 16:15:33 GMT

check this and let me know

Re: Jazzing up a pivot table

Mon, 02 Jun 2014 16:25:34 GMT

See the attached file, I did some formatting with the dimension background color and text color.

Re: Jazzing up a pivot table

Mon, 02 Jun 2014 16:42:39 GMT

See attached.

Re: Jazzing up a pivot table

Daniel_Moore — Wed, 04 Jun 2014 19:51:55 GMT

Thanks for the ideas everybody! After some thought I decided to 'pivot' my question. What a pun- cause a straight table looks more like the original report:

I added some if statements in the load script to make the pivots & subtotals work:

if(left(Status,3)='Ope',if(left(Severity,1) ='H',1,0),0) as OpenH,

if(left(Status,3)='Ope',if(left(Severity,1) ='H',0,1),0) as OpenL,

if(left(Status,3)='Ope',1,0) as Open,

etc.

I think that's closer to the original report. Agreed?