topic Re: variables issues in QlikView

variables issues

vengadeshpalani — Wed, 25 Nov 2020 16:16:04 GMT

I have created variable in script level when I use this variable in text object I face below issue... how can I modify variable?

set try = '=num(sum({<[Interval Group]={'15-minute'},[Meter ID]= ,[Bill Group]= >}(aggr_IntervalsReceived))/sum({<[Interval Group]={'15-minute'},[Meter ID]= ,[Bill Group]= >}(aggr_IntervalsExpected)),'#,##0.00%')' ;

Re: variables issues

hic — Thu, 23 Nov 2017 12:05:37 GMT

You cannot nest single quotes like that. Try double quotes instead.

Set try = "= ... "

HIC

Re: variables issues

ashwinishinde — Thu, 23 Nov 2017 12:09:52 GMT

Dear vengadeshpalani,

Try This

let try = num(sum({<[Interval Group]={'15-minute'},[Meter ID]= ,[Bill Group]= >}(aggr_IntervalsReceived))/sum({<[Interval Group]={'15-minute'},[Meter ID]= ,[Bill Group]= >}(aggr_IntervalsExpected)),'#,##0.00%') ;

Thanks & Regards,

Ashwini