Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

Presentation in Straight or Pivot Table

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..

Capture.JPG

Hope you understand..

Thanks in Advance..

PFA,

7 Replies
Highlighted

Re: Presentation in Straight or Pivot Table

May be like this:

Capture.PNG

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

Highlighted
Specialist II
Specialist II

Re: Presentation in Straight or Pivot Table

Thanks sunny..

Can we show like.. Capture.JPG

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

Highlighted

Re: Presentation in Straight or Pivot Table

Like this?

Capture.PNG

Highlighted
Specialist
Specialist

Re: Presentation in Straight or Pivot Table

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


pivot.png


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


Highlighted
Specialist II
Specialist II

Re: Presentation in Straight or Pivot Table

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

If make selection also i want to show empty line.

Highlighted
Specialist II
Specialist II

Re: Presentation in Straight or Pivot Table

HI sunny,

Is this possible??

Highlighted

Re: Presentation in Straight or Pivot Table

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