Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
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
Henric_Cronström

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

Set try = "= ... "

HIC

View solution in original post

2 Replies
Henric_Cronström

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

Set try = "= ... "

HIC

View solution in original post

ashwinishinde
Partner
Partner

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