topic Re: help in expression in QlikView

help in expression

Mon, 30 Jun 2014 04:35:15 GMT

Hi,

In my sample application in the table box there is a field 'newstock', for the 'newstock' I need an expression that should the current month highest data, if the data isn't present for that month it should show the previous month highest data like vice versa

Re: help in expression

Mon, 30 Jun 2014 04:42:06 GMT

In detail If my current selection is equal to Month then it should display the maximum of NewStock. If the newstock is null then it should go to the immediate previous month as this condition should repeat

Re: help in expression

sasikanth — Mon, 30 Jun 2014 04:58:54 GMT

Try some thing lIke this

if( isNull(max({<month={'&(=max(Month-filed))'}>} NewStock)),max({<month={'&(=max(month-filed-1))'}>}NewStock),max({<month={'&(=max(Month-filed))'}>} NewStock))

Re: help in expression

Mon, 30 Jun 2014 05:31:50 GMT

Thanks for the reply but the expression is not working

Re: help in expression

sasikanth — Mon, 30 Jun 2014 07:06:51 GMT

Try Some thing Like this

if(Month=max(Month),if( isNull(NewStock),Month=max(Month-1) and max(NewStock),max(NewStock))