Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

Set try = "= ... "

HIC

View solution in original post

2 Replies
Highlighted

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

Set try = "= ... "

HIC

View solution in original post

Highlighted
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