topic Re: split data in QlikView

split data

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have below data. The values in the location column has both Location and Sub-Location data. So i want to move the sub-location values into separate fields.

Lookup_Table: //Location to Sub-location mapping table.

LOAD * INLINE

[

Location,SubLocation

NCR,Del

];

data:

LOAD * INLINE [

Product, Location,Sales

A, NCR,100

A, Del,150

A, NCR,200

B, SN,200

];

As location also include sub-location the total sales of NCR location should be 450.

So, when a user click on NCR value sales should be shown as 450. If user click on Del the sales should be 150.

In the UI i want to put Location and Sub-Location in each listbox. so location should have location values and sub-location should have only sub-location values in it.

Please help.

Re: split data

Anonymous — Tue, 21 Nov 2017 09:43:38 GMT

Hi Suraj,

You may need the look table in the attached mapping table format. Find the attachment and let me know if still facing any issues.

-Jai

Re: split data

PrashantSangle — Tue, 21 Nov 2017 09:48:21 GMT

Load same table twice with alising

like below,

Final:

Load Location as finalLocation

from Test;

concatenate

Load SubLocation as finalLocation

from Test;

Regards,

Re: split data

surajap123 — Tue, 21 Nov 2017 10:05:33 GMT

Thanks for your reply.

The location values should not be in Sub-location and vice versa. The ones highlighted below should not be in present in their respective fields.

Expected output-->

Please help.

Re: split data

antoniotiman — Tue, 21 Nov 2017 10:06:16 GMT

Where "user click on Del", in Location or SubLocation Listbox ?

Re: split data

surajap123 — Tue, 21 Nov 2017 10:07:45 GMT

Hi Prashant,

I didn't get how i can solve by concatenation. There is no SubLocation field in my main table and i want data to be splitted, so that sub-location data is not in location field and location data is not in sub-location field. However the Location with sub-location should show complete sales(ie. sales of both location and its sub-location.)

Re: split data

surajap123 — Tue, 21 Nov 2017 10:08:27 GMT

Sub-Location.

Please see the lookup table.

Re: split data

PrashantSangle — Tue, 21 Nov 2017 10:29:26 GMT

Sorry my bad.

I interpret incorrectly.

Regards,

Re: split data

el_aprendiz111 — Tue, 21 Nov 2017 16:01:28 GMT

Hi,