topic Variable not working in setanalysis in QlikView

Variable not working in setanalysis

Wed, 26 Nov 2014 12:30:36 GMT

Hello All,

Can any one please answer me why the below expression is not working in pivot table

count( if($(vTime1) > 34600, articleId))

dimension is MonthYear

Note : $vTime1 =

(Subfield(Interval($(vSum1),'hh:mm:ss'),':',1)*60*60)+

(Subfield(Interval($(vSum1),'hh:mm:ss'),':',2)*60)+

(Subfield(Interval($(vSum1),'hh:mm:ss'),':',3))

Anonymous — Wed, 26 Nov 2014 13:21:40 GMT

Hi Divya

Try using else condition and check the expression again like this

count( if($(vTime1) > 34600, articleId,'less than 34600'))

Regards

Harsha

Wed, 26 Nov 2014 13:28:03 GMT

Try using without $() like the below

=(Subfield(Interval(vSum1,'hh:mm:ss'),':',1)*60*60)+

(Subfield(Interval(vSum1,'hh:mm:ss'),':',2)*60)+

(Subfield(Interval(vSum1,'hh:mm:ss'),':',3))

count( if(vTime1 > 34600, articleId))

goncalo_ricardo_pereira — Wed, 26 Nov 2014 13:30:20 GMT

Hello Divya,

Perhaps you want something like this:

count({$<Time_Field={">=$(=num($(vTime1)))"}>} articleId)

Best Regards.

Gonçalo Pereira