topic Re: Generating SVG File in Qlikview Issue in QlikView

Generating SVG File in Qlikview Issue

rustyfishbones — Thu, 27 Jul 2017 09:52:17 GMT

Hi All,

I am trying to generate an SVG file in Qlikview, however I get a problem when I output the file to the .svg

I have the following script in Qlik, I am using a preceding load to add double quotes around the necessary text

In the Qlikview file it's correct, but when it outputs to the SVG file I have quotes around my quotes like below

How can I remove the Quotes so that I end up with the following

Re: Generating SVG File in Qlikview Issue

Gysbert_Wassenaar — Thu, 27 Jul 2017 10:02:03 GMT

Can't be done with Qlikview script afaik. You could store the output in a .svg file and then process that file to remove the extra quotes with for example powershell script command:

cat .\WaffleChart.svg | % { $_ -replace """""", "@@" } | % {$_ -replace """", "" } | % {$_ -replace "@@", """"}

Using sed or a python script are some other options.

Re: Generating SVG File in Qlikview Issue

Frank_Hartmann — Thu, 27 Jul 2017 10:55:38 GMT

You could also try using a macro

see attached

hope this helps

Re: Generating SVG File in Qlikview Issue

rustyfishbones — Thu, 27 Jul 2017 11:17:56 GMT

I have never used powerscript before.

could I execute a .bat file from Qlikview to run powerscript and remove the Quotes?

Re: Generating SVG File in Qlikview Issue

rustyfishbones — Thu, 27 Jul 2017 11:18:37 GMT

Thanks Frank, this works perfectly

Re: Generating SVG File in Qlikview Issue

rustyfishbones — Thu, 27 Jul 2017 11:21:15 GMT

Hi Gysbert,

Do you mean PowerShell command?

Regards

Alan

Re: Generating SVG File in Qlikview Issue

Gysbert_Wassenaar — Thu, 27 Jul 2017 12:06:59 GMT

uh yeah, that.

Re: Generating SVG File in Qlikview Issue

rustyfishbones — Fri, 28 Jul 2017 09:48:40 GMT

Hi Gysbert,

So I got it working with the following Powershell script to remove unwanted Quotes

Set-ExecutionPolicy Unrestricted

(Get-content .\WaffleChart.svg) | ForEach-Object{$_ -replace "`"`"", "`""} | ForEach-Object{$_ -replace "`"<", "`<" } | ForEach-Object{$_ -replace ">`"", ">" } | Set-content .\WaffleChart.svg

And I managed to EXECUTE from Qlikview script - needed to make a few changes in

User Preferences>>Secuirty etc..

But I got it working with the following Qlikview Script.

LET title = 'WaffleChart';

SVG:

LOAD * INLINE [

<Title>"$(title)"</Title>

<g>

];

LET y = 5;

LET x = 15;

LET width = 15;

LET height = 15;

LET strokewidth = 1;

LET stroke = '#ff0000';

LET fill = 'white';

LET id = 1;

for j = 1 to 10

FOR i = 1 to 10

concatenate(SVG)

LOAD * INLINE [

];

LET x = $(x) + $(width);

LET id = $(id) + 1;

NEXT i

LET y = $(y) + $(height);

LET x = $(width);

NEXT j

concatenate(SVG)

LOAD * INLINE [

</g>

</svg>

];

STORE SVG INTO .\WaffleChart.svg (txt);

//Ensure Security Settings are all ticked in User Preferences

LET ps = 'C:\Users\Alan.PRINCIPAL\Desktop\SVG\wafflechart.ps1';

EXECUTE powershell.exe $(ps);