Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_testing
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
sunny_talwar

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

qv_testing
Specialist II
Specialist II
Author

Thanks sunny..

Can we show like.. Capture.JPG

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

sunny_talwar

Like this?

Capture.PNG

ziadm
Specialist
Specialist

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


qv_testing
Specialist II
Specialist II
Author

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

If make selection also i want to show empty line.

qv_testing
Specialist II
Specialist II
Author

HI sunny,

Is this possible??

sunny_talwar

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