Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vengadeshpalani
Creator
Creator

variables issues

Hi

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%')' ;

1.png

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

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

Set try = "= ... "

HIC

View solution in original post

2 Replies
hic
Former Employee
Former Employee

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

Set try = "= ... "

HIC

ashwinishinde
Partner - Contributor III
Partner - Contributor III

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