How to upload one string

[#1]

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

[Miguel_Angel_Baeyens]

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.

[Aurelien_Martinez]

Hi,

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

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

repeat for all measure

Aurélien

[#4]

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

[#5]

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

[tamilarasu · Accepted solution]

Hello Roman,

Have a look at the attached file.

[#7]

thank you)