Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variable not working in setanalysis

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))

3 Replies
Anonymous
Not applicable
Author

Hi Divya

Try using else condition and check the expression again like this

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

Regards

Harsha

Not applicable
Author

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
Partner - Contributor III
Partner - Contributor III

Hello Divya,

Perhaps you want something like this:

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

Best Regards.

Gonçalo Pereira