topic Re: where to put variable in QlikView

where to put variable

kunkumnaveen — Mon, 01 Aug 2016 10:26:42 GMT

Hello All,

i have a variable

set vdate= 'date=,week=';

and i have a exp:

Num(sum( aggr ( avg(units),Date, top,Work )) ,'#,##0')

i want to add a varible in to this exp ,i tried over here which is not working

Num(sum( aggr ( avg(units),$(vdate),Date, top,Work )) ,'#,##0')

so where should i need to put this variable so that if i select any date it should not reflect my chart

thanks

naveen

sunny_talwar — Mon, 01 Aug 2016 10:28:18 GMT

May be like this:

Num(Sum({<$(vdate)>} Aggr(Avg({<$(vdate)>} units), Date, top, Work)) ,'#,##0')

kaushiknsolanki — Mon, 01 Aug 2016 10:28:24 GMT

Try this.

Num(sum( {<$(vdate)>} aggr ( avg({<$(vdate)>}units),Date, top,Work )) ,'#,##0')

Regards,

Kaushik Solanki

miguelbraga — Mon, 01 Aug 2016 10:32:23 GMT

Hey there,

Why not the vDate Variable be something like this:

vDate = Max(Date).

This way you can get the values from your selected Date.

Hope this helps you, if not please tell me,

Regards,