topic Re: looping functions in Expressions in QlikView

looping functions in Expressions

Fri, 27 Jun 2014 05:55:01 GMT

HI Qlikers,

i have a pivot table of stock with buyer and date as dimension and stock as expressions.

now i want to compare for each date if the stock is continuously same then we should display that value to that respected dates otherwise zero has to be dispalyed.

Thanks in Advance

Sampath Botla

Re: looping functions in Expressions

Fri, 27 Jun 2014 05:56:59 GMT

you can address at the script level.

load

if(stock=peek(stock),stock, 0) as stock

...

resident <tab>

order by <date>;

Re: looping functions in Expressions

Fri, 27 Jun 2014 05:59:38 GMT

if you want to do it in the expression say like this.

if (stock=above(stock), stock, 0)

if it is a pivot table

if (stock=before(stock), stock, 0)

Re: looping functions in Expressions

Fri, 27 Jun 2014 06:36:34 GMT

i have written a big expression which can be done in script level.

Thank you