topic Re: Straight Table Calculation... in QlikView

Straight Table Calculation...

israrkhan — Mon, 16 Mar 2015 10:13:37 GMT

Hi Guys..

i have a table like below..

in straight table i want to calculate the balanceamount, my dimension is DocCode,

and expression is sum({<DISTDATE = {"<= $(=Max(Date(DISTDATE,'DD/MM/YYYY')))"}>} BalanceAmount)

its giving me 0,

let say if i select date 20/04/2014, the balance amount must be 500,

and if i chose date 22/04/2014 the balanceamount must be 300, (which is 500-200)

date format is DD/MM/YYYY..

HOW TO USE <= OPERATOR IN SET ANALYSIS....VERY SIMPLE BUT NOT WORKING ....

PLEASE SUGGEST....

Header 1	Header 2	Header 3
DocCode	DisDate	Amount
1	20/04/2014	500
1	22/04/2014	-200
1	25/04/2014	-300
2	30/04/2014	800

Re: Straight Table Calculation...

sunny_talwar — Mon, 16 Mar 2015 10:27:53 GMT

Try by creating a variable and then doing it.

It worked for me when I did this:

vMaxDate = Date(Max(DisDate))

Expression: Sum({<DisDate = {'<=$(vMaxDate)'}>} Amount)

HTH

Best,

Re: Straight Table Calculation...

hic — Mon, 16 Mar 2015 10:28:05 GMT

You need to use

=Date(Max(DISTDATE),'DD/MM/YYYY')

instead of

=Max(Date(DISTDATE,'DD/MM/YYYY'))

HIC

Re: Straight Table Calculation...

Mon, 16 Mar 2015 10:38:59 GMT

Hi,

Use this Application.

Regards

Vimlesh

Re: Straight Table Calculation...

awhitfield — Mon, 16 Mar 2015 10:56:36 GMT

Can you post a sample of the data being loaded in an xls, the names of fields in you screen shot appear to be different from those in the expression formula.