topic Re: How to upload one string in QlikView

How to upload one string

Mon, 28 Nov 2016 15:34:14 GMT

Hello, guys, I am bery new to Qlik and i need to make a task: upload xls file into QlikView but the file contains a filed which indentifies if string values are target or not.

EXAMPLE

product	status	amount	revenue	date
product1	target	10	1000	05/01/2016
product1	actual	7	700	07/01/2016
product1	actual	3	300	07/01/2016

In total i need to get a table like this

product	amount target	revenue target	amount actual	revenue actual	date target	date actual
product1	10	1000	10	1000	05/01/2016	07/01/2016

Data's given like in the very 1st table. How to make one string out of all those 3

Re: How to upload one string

Miguel_Angel_Baeyens — Mon, 28 Nov 2016 15:38:13 GMT

Welcome to QlikView and the Community Roman,

In the script editor (Ctrl + E) do something as follows, replacing my dummy names by your own:

Table:

LOAD product,

status,

amount,

revenue,

date

FROM

(biff, embedded labels, table is Sheet1$)

WHERE status = 'target';

Then click save and then reload.

Re: How to upload one string

Aurelien_Martinez — Mon, 28 Nov 2016 15:39:06 GMT

Hi,

amount target => Sum({<status = {'target'}>} amount)

amount actual=> Sum({<status = {'actual'}>} amount)

repeat for all measure

Aurélien

Re: How to upload one string

Tue, 29 Nov 2016 07:28:38 GMT

thank you Miguel but i gues if i use that part of the script ill get target strings only without any actual ones

Re: How to upload one string

Tue, 29 Nov 2016 07:29:35 GMT

Aurelien, is it about measure contructure? i need it to be in script

Re: How to upload one string

tamilarasu — Tue, 29 Nov 2016 08:04:03 GMT

Hello Roman,

Have a look at the attached file.

Re: How to upload one string

Tue, 29 Nov 2016 08:05:30 GMT

thank you)