topic Re: formula not working when put in a table in QlikView

formula not working when put in a table

samuel_brierley — Mon, 09 Feb 2015 14:06:46 GMT

hi all,

i have the below formula (its a length one) that works fine in a text box and with a single date filtered but when i paste it into a chart with date as the dimension it nulls out. if i filter to one day the formula works in the table but obviously defeats the point..

thanks for any help.

num

((10-Sum(Aggr( if( ArbitrationInput.Group.rQo = only( {$< [/rec/parameter] = {'rMin'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval]) and
ArbitrationInput.Group.rOOk < only( {$< [/rec/parameter] = {'rMax'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval]) and
below(ArbitrationInput.Group.rQo,1,1) > only( {$< [/rec/parameter] = {'rMin'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval]), 1,'')
,Time))
/( sum(aggr(if(ArbitrationInput.Group.rOOk < 950,1,''),Time))/60)/1.5),'##')

Re: formula not working when put in a table

robert_mika — Mon, 09 Feb 2015 14:19:38 GMT

Could you attached your file?

Re: formula not working when put in a table

rubenmarin — Mon, 09 Feb 2015 14:20:06 GMT

Hi Samuel, you can try to add Date to the aggr function:

((10-Sum(Aggr( if( ArbitrationInput.Group.rQo = only( {$< [/rec/parameter] = {'rMin'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval]) and
ArbitrationInput.Group.rOOk < only( {$< [/rec/parameter] = {'rMax'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval]) and
below(ArbitrationInput.Group.rQo,1,1) > only( {$< [/rec/parameter] = {'rMin'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval]), 1,'')
, Date,Time))
/( sum(aggr(if(ArbitrationInput.Group.rOOk < 950,1,''), Date,Time))/60)/1.5),'##')

Re: formula not working when put in a table

samuel_brierley — Mon, 09 Feb 2015 14:26:58 GMT

You absolute beaut!!! so obvious now i just assumed adding it into the dimension would do this.

thanks