topic Re: Presentation in Straight or Pivot Table in QlikView

Presentation in Straight or Pivot Table

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

Hi Community,

I have one requirement.. in Pivot table or Straight table

Example:

I have Month wise data.. but i want to split first 3 months, 6 months and Last 3 months.

This is my data in Pivot table, working perfect.

but my requirement i want to show empty line for group level..

Hope you understand..

Thanks in Advance..

PFA,

Re: Presentation in Straight or Pivot Table

sunny_talwar — Tue, 24 May 2016 18:38:46 GMT

May be like this:

Add a new Inline table like this:

LOAD Month(Date#(Month, 'MMM')) as Month,

Group

Inline [

Month, Group

Jan, 1

Feb, 1

Mar, 1

Apr, 2

May, 2

Jun, 2

Jul, 2

Aug, 2

Sep, 2

Oct, 3

Nov, 3

Dec, 3

];

And use Group as the very first dimension in the chart

Re: Presentation in Straight or Pivot Table

Nagaraju_KCS — Tue, 24 May 2016 18:50:23 GMT

Thanks sunny..

Can we show like..

After one group, i want to show one empty line..

Re: Presentation in Straight or Pivot Table

sunny_talwar — Tue, 24 May 2016 19:09:55 GMT

Like this?

Re: Presentation in Straight or Pivot Table

ziadm — Tue, 24 May 2016 19:15:37 GMT

change your master Calendar to and add another dimension

if (Month >= 1 and Month <= 3,'G1',if(Month > 3 and Month <= 6,'G2','G3')) as MonthGroup

make a pivot table and add these dimensions

MonthGroup

Month

make you expression as sum of sale

The Pivot table will be close of what you are looking for

Re: Presentation in Straight or Pivot Table

Nagaraju_KCS — Thu, 26 May 2016 03:19:29 GMT

But, The empty line i want to standardized for each group.

If make selection also i want to show empty line.

Re: Presentation in Straight or Pivot Table

Nagaraju_KCS — Thu, 26 May 2016 16:27:40 GMT

HI sunny,

Is this possible??

Re: Presentation in Straight or Pivot Table

sunny_talwar — Thu, 26 May 2016 16:29:02 GMT

I will need to do some testing. I will get back with my findings. Sorry for the delay