Discussion board where members can get started with QlikView.
I have one requirement.. in Pivot table or Straight table
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..
May be like this:
Add a new Inline table like this:
LOAD Month(Date#(Month, 'MMM')) as Month,
And use Group as the very first dimension in the chart
Can we show like..
After one group, i want to show one empty line..
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
make you expression as sum of sale
The Pivot table will be close of what you are looking for
But, The empty line i want to standardized for each group.
If make selection also i want to show empty line.
Is this possible??
I will need to do some testing. I will get back with my findings. Sorry for the delay