topic Re: Set Analysis Problem in QlikView

Set Analysis Problem

Tue, 28 May 2013 06:50:05 GMT

Hey there,

im facing a wird problem and i dont know how to fix it.

I wanna show the begging_balance for my min selection on months and the ending_balance for the max selection on months. (see Attached File)

For the ending_balance the following expression is working fine:

sum({$< PERIOD_NUM= {$(=(MAX(PERIOD_NUM)))}>}ENDING_BALANCE)

Problem comes with the beggining_balance expression since is returning always 0 even if the data is there in a normal table.

The expression is the following:

sum({$< PERIOD_NUM= {$(=(MIN(PERIOD_NUM)))}>} BEGINNING_BALANCE)

Any hint will be appreciated since i dont know what else i can try.

Cheers

Juan Pedro

Tue, 28 May 2013 07:21:19 GMT

try this

sum({$< PERIOD_NUM= {1(=(MIN(date#(PERIOD_NUM,'MM'))))}>} BEGINNING_BALANCE)

nizamsha — Tue, 28 May 2013 07:33:58 GMT

wht u r asking i think ur ending balance of last month should be the opening balance for next is it so if it mean use rangesum

=rangesum(above (TOTAL sum(BEGINNING_BALANCE),0, rowno(TOTAL)))

Tue, 28 May 2013 07:44:28 GMT

thanks for the anserw.

The problem was that QlikView decided that the beggining_balance was a text column

forced number in the script using

Num#(BEGGINING_BALANCE) AS BEGGINING_BALANCE

Everything is working fine now.

Cheers

Juan Pedro