Blank column Seperator

[nareshthavidishetty]

Hi,

We need to insert an bank Column in the table as below which is marked as red to differentiate the table.

Thanks..

[nareshthavidishetty]

Hi Sunny,

May i know what you done to get this.Please let me know can't figure out.

Thanks..

[sunny_talwar · Accepted solution]

I have attached the QlikView document with my response. But essentially, this was the old expression

If(SNo2 = 1,

Num(Pick(Match(SNo1, 1, 3, 5, 7),

  [Sales MTH],

  [Sales RQTR],

  [Sales YTD],

  [Sales MAT]), '#.##0'),

Num(Pick(Match(SNo1, 1, 3, 5, 7),

  [Growth MTH],

  [Growth RQTR],

  [Growth YTD],

  [Growth MAT]), '##.0%'))

and this is the new one:

If(SNo2 = 1,

Pick(SNo1,

  Num([Sales MTH], '#.##0'),

  Dual(' ', 1),

  Num([Sales RQTR], '#.##0'),

  Dual(' ', 1),

  Num([Sales YTD], '#.##0'),

  Dual(' ', 1),

  Num([Sales MAT], '#.##0')),

Pick(SNo1,

  Num([Growth MTH], '##.0%'),

Dual(' ', 1),

  Num([Growth RQTR], '##.0%'),

Dual(' ', 1),

  Num([Growth YTD], '##.0%'),

  Dual(' ', 1),

  Num([Growth MAT], '##.0%')),)

So, all I did was to assign a value of 1 to the column which was getting suppressed because it was null before. Does this make sense?

[nareshthavidishetty]

Thanks...Sunny