topic Re: set analysis expression in QlikView

set analysis expression

Sun, 10 Nov 2013 12:52:27 GMT

Hi,

Can someone help me to understand the next expression?

sum({$<

METRIC_TYPE={'TtO' }

, CREATIONTIME={">= $(= vFromDate ) < $(= vToDate +1)"}

>} $(TIME_FACTOR) )

Thanks,

Boris

Re: set analysis expression

israrkhan — Sun, 10 Nov 2013 13:45:18 GMT

Hi,

vFromDate = taking input from user are have assigned a default value

vToDate, same like above, but adding +1 day

This Expression is doing Sum of Time_Factor, that is a field in Data Source.

But Only those Time Factor, Where Metric_Type = "Tto" and Creation_Time is Greater Than or equal to vFromDate and

Creation_Time Less Than vToDate plus one day,

for example vToDate contain a date like 20/11/2013, then vToDate + 1 will be 21/11/2013.

Hope will help,

sorry if i could not explain well

Re: set analysis expression

Anonymous — Sun, 10 Nov 2013 15:28:36 GMT

IsrarKhan,

Looks correct except of the $(TIME_FACTOR). From the expression syntax it is rather a variable than a field. That is, the expression returns sum of the field specified in this variable, with the conditions as you've described.

Regards,

Michael

Re: set analysis expression

israrkhan — Sun, 10 Nov 2013 15:32:49 GMT

Hi Michael,

OOOPS , did not realized that its a variable.

Thanks for corrections.

Re: set analysis expression

Sun, 10 Nov 2013 15:38:35 GMT

It is indeed a field that is assigned into this variable.

does it mean that the sum is for all the values in this field even if it is assigned to a variable?

Thanks,

Re: set analysis expression

Yousef_Amarneh — Sun, 10 Nov 2013 23:47:50 GMT

I think yes

Re: set analysis expression

israrkhan — Mon, 11 Nov 2013 06:52:15 GMT

no , not sum for all value,but for those value, who fall in the below criteria,

Where Metric_Type = "Tto" and Creation_Time is Greater Than or equal to vFromDate and

Creation_Time Less Than vToDate plus one day.