Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

How to upload one string

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

productstatusamountrevenuedate
product1target10100005/01/2016
product1actual770007/01/2016
product1actual330007/01/2016

 

In total i need to get a table like this

productamount targetrevenue targetamount actualrevenue actualdate targetdate actual
product110100010100005/01/201607/01/2016


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

1 Solution

Accepted Solutions

Re: How to upload one string

Hello Roman,

Have a look at the attached file.

Capture.PNG

View solution in original post

6 Replies

Re: How to upload one string

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.

Partner
Partner

Re: How to upload one string

Hi,

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

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

repeat for all measure

Aurélien

Not applicable

Re: How to upload one string

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

Not applicable

Re: How to upload one string

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

Re: How to upload one string

Hello Roman,

Have a look at the attached file.

Capture.PNG

View solution in original post

Not applicable

Re: How to upload one string

thank you)