Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to make table 2 display 360 ?

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

1 Solution

Accepted Solutions

Re: How to make table 2 display 360 ?

Or this:

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


Capture.PNG

3 Replies

Re: How to make table 2 display 360 ?

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

Re: How to make table 2 display 360 ?

Or this:

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


Capture.PNG

paulyeo11
Valued Contributor II

Re: How to make table 2 display 360 ?

Hi Sunny

it work many thank.

Paul

Community Browser