topic Re: Need Expression in straight table in QlikView

Need Expression in straight table

Wed, 12 Feb 2014 09:57:15 GMT

Hello Every one,

Please give me solution for the below query. I need a expression in straight table.

Concept :- In my application, we have four depots (S1,S2,S3,S4). In all depots same part no available (Eg:- "A"). But Supplier code's will be differ. For S1 depot, XYZ is the supplier code. But for remaining depots (S2,S3,S4) -- > S1 is the supplier code.

Now, I need to create a straight table , where I need to show the base supplier code. Hope you ppl understand my query. Please provide solution asap. Thanks in advance.

Sample data :-

Re: Need Expression in straight table

vikasmahajan — Wed, 12 Feb 2014 10:19:09 GMT

attach sample qvw

Re: Need Expression in straight table

kiranmanoharrode — Wed, 12 Feb 2014 10:37:55 GMT

try Below expression

=Only(SUPPLIER CODE)

Regards

Kiran

Re: Need Expression in straight table

ashwanin — Wed, 12 Feb 2014 10:44:34 GMT

Its a tricky one if you have only two supplier. ie s1 and XYZ. But if you have multiple supplier, then have to think in different way.

Re: Need Expression in straight table

amit_saini — Wed, 12 Feb 2014 11:07:03 GMT

Hi Reenaabraham,

Write this in expression for calculating Supplier:

if(Supplier,'S1','XYZ')

Thanks,

Re: Need Expression in straight table

sudeepkm — Wed, 12 Feb 2014 12:19:29 GMT

I've a solution that can work for multiple DEPOT and Supplier data.

1. I've created a sample data like below.

2. Objective is to create another field in the script as NEWSUPP which will have values like below

3. This is how you can do it at script level.

dptmap:

Mapping LOAD

DEPOT,SUPPLIER

FROM

dEPOTsUPPLIER.xlsx (ooxml, embedded labels, table is Sheet1);

dpt:

LOAD DEPOT,

PART,

SUPPLIER,

ApplyMap('dptmap',SUPPLIER,SUPPLIER) as NWSUPP

FROM

dEPOTsUPPLIER.xlsx (ooxml, embedded labels, table is Sheet1);

4. In the UI your straight table may use the new field NWSUPP.

Attached xls and QVW are for reference.

Re: Need Expression in straight table

jonathandienst — Wed, 12 Feb 2014 12:25:21 GMT

At the moment everyone is pretty much guessing.

You need to explain how to select the "base" supplier code. Is it always depot S1, or the first instance in the file or some other method?

Jonathan

Re: Need Expression in straight table

Fri, 14 Feb 2014 10:29:07 GMT

Hello Every one,

Sorry for late response.

In my case, I have 50 k parts with different supplier code's. Base supplier is S1 only in all case's.

Please find my requirement below. Please let me know the solution for same. Thanks in advance.

Re: Need Expression in straight table

Fri, 14 Feb 2014 10:31:00 GMT

Hello,

If there is only 1 part then your solution is fine. But in my case, I have many parts. Please find my reply for the requirement. Thank you.

Re: Re: Need Expression in straight table

sudeepkm — Fri, 14 Feb 2014 11:15:56 GMT

you may try the composite key that means considering DEPOT and PART as a single field.

Please find the attached QVW. Given below is how it looks in QlikView.