topic Combine 2 formula's in QlikView

Combine 2 formula's

francisvandergr — Thu, 26 May 2011 08:37:42 GMT

In my dashboard i have this formula :

='Debiteuren ' & num(sum(if(Grootboek\Rubriek = '02.02.02',Grootboekmutatie\Bedrag)) /

sum(if(Grootboek\Rubriek = '16.00.10',Grootboekmutatie\Bedrag*-1)),'##,#')

I select a period in my dashboard but for formula above i want all period till the selected period. I know this is te fomula for it :

=sum({< Month = {"<=$(=max(Month))"} >} Amount)

=sum({< Periode = {"<=$(=max(Periode))"} >} Amount)

Now i want combine those formula. How can i do this ? I hope someone can help me

Re: Combine 2 formula's

ToniKautto — Thu, 26 May 2011 08:42:23 GMT

You mean combine into one set expression?

Is this waht you are looking for?

=sum({< Month = {"<=$(=max(Month))", Periode = {"<=$(=max(Periode))"} >} Amount)

This will caluculate the sum of amount on the current selection, with month set to max month value and period set to max period value from within the current selection.

Combine 2 formula's

francisvandergr — Thu, 26 May 2011 13:12:53 GMT

No this is not the answer for me. What i want is:

When someone for example select period 5 in a listbox then qv must calculate in the formula above with periode 0,1,2,3,4 and 5

Combine 2 formula's

ToniKautto — Thu, 26 May 2011 13:26:06 GMT

Not tried if the exact syntax is correct, but the principle should be something like this.

getfieldselections() - Get the selected values from the list

getselectedcount() - Get the number of selected values, the highest index is assumed to be the max value

subfield() - Find the selected value matching the max index

subfield( getfieldselections( yourfieldname, ';' ), ';', getselectedcount( yourfieldname ) )