topic Re: How to make table 2 display 360 ? in QlikView

How to make table 2 display 360 ?

paulyeo11 — Fri, 25 Dec 2015 16:00:38 GMT

Hi All

When i select 2014 Table 1 Day30 , display every row 30 and last row display 360.

How to make Table 2 display :-

when i select year = 2014 , it will display 360

MK_QSL — Fri, 25 Dec 2015 18:27:28 GMT

If(sum(STK_CLOSE) > 0 and sum(STK_OPEN) > 0, IF(Mod(RowNo(),12)=0,360,30))

sunny_talwar — Fri, 25 Dec 2015 21:46:34 GMT

Or this:

If(sum(STK_CLOSE) > 0 and sum(STK_OPEN) > 0, Max(Month(YearMonth))*30)

paulyeo11 — Fri, 25 Dec 2015 22:38:47 GMT

Hi Sunny

it work many thank.

Paul