Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We need to insert an bank Column in the table as below which is marked as red to differentiate the table.
Thanks..
Hi Sunny,
May i know what you done to get this.Please let me know can't figure out.
Thanks..
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?
Thanks...Sunny