topic Re: Help with DATA Load in QlikView

Help with DATA Load

arusanah — Tue, 22 Nov 2016 19:59:51 GMT

I am getting data for Product table in csv file. I don't have Category field in Data source. I am trying to generate category field in script as :

table A:

id,

county,

region,

'Electronics ' as [ Category Type] // Inscript Field

From

ASD*.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

Concatenate

Load id,

county,

region,

'Books ' as [ Category Type] // Inscript Field

From

ASD*.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

But it doubles my data . which results incorrect count . any help will be highly appreciated

Re: Help with DATA Load

sunny_talwar — Tue, 22 Nov 2016 20:01:25 GMT

The same data is Electronics and Books? Not sure what you are trying to do?

Re: Help with DATA Load

arusanah — Tue, 22 Nov 2016 20:23:40 GMT

data is in following Format:

count of books | count Of electronic

I have to show 3 text boxes on Dashboard .

1) Total sales which is count of Book + Electronics

2) Total electronics Sold

3) Total books Sold

they want to have functionality for ist text box to see only Book or only Electronics based on product Category Type.

thatz why I wanted to create inscript field

Re: Help with DATA Load

sunny_talwar — Wed, 23 Nov 2016 01:39:14 GMT

But how would you distinguish between the two outside of QlikView? You somehow need to distinguish between the two right? what is that distinguishing thing or things?

Re: Help with DATA Load

maksim_senin — Wed, 23 Nov 2016 02:31:47 GMT

Hi,

It's very strange approach to data modeling. Your data are doublicated because the script loads them twice from the same source. Moreover, it is not clear how you're planing to group them by [Category Type] if its values are the same for each line in each load... I suppose the category should come from the source or at least calculated somehow by some formula.

Please think out your data model first.

Best regards,

Maxim