topic Re: General Query in QlikView

General Query

Mahamed_Qlik — Tue, 04 Aug 2015 05:53:20 GMT

Hello Guys,

I need one field named as "Products" listed below:

Products
Small
Large
Total

And if Click on Small the it should show Small Products (A,B) only.

And if Click on Large then it should show Large Products (C,D,E)only,

And if Click on Total then it should show all the Products (A,B,C,D,E,F).

I have following field on all the product named as Link_Product

Link_Product
A
B
C
D
E
F
G

Small Products are : A, B

Large Products are: C,D,E

Total Total Products are: A,B,C,D,E,F (Excluding G)

Kindly suggest.

Re: General Query

Mahamed_Qlik — Tue, 04 Aug 2015 05:57:34 GMT

I need to create the Products field in script (Back End)

Re: General Query

jonathandienst — Tue, 04 Aug 2015 05:58:21 GMT

Load the products in a way that associates the product types with the products:

LOAD *

Inline

[

Product, Type

A, Small

B, Small

C, Large

D, Large

E, Large

];

Total is the same as nothing selected, so you dont really need that. But if you insist on doing that, add

A, Total

B, Total

...

to the load above.

(The inline load is for example purposes - change the inline load to whatever source you are loading from)

Re: General Query

senpradip007 — Tue, 04 Aug 2015 06:02:37 GMT

Can you share sample qvw ?

Re: General Query

MayilVahanan — Tue, 04 Aug 2015 06:02:37 GMT

Try like this

Test:

LOAD *, if(Match(Link_Product, 'A', 'B'), 'Small', if(Match(Link_Product, 'C', 'D', 'E'), 'Large')) AS Product Inline

[

Link_Product

];

Load Link_Product, if(not Match(Link_Product, 'G'), 'Total') AS Product Resident Test;

Re: General Query

qlikmsg4u — Tue, 04 Aug 2015 06:05:42 GMT

Please find the attached app and script

Product:

Load*,If(Match(Link_Product,'A','B'),'Small',If(Match(Link_Product,'C','D','E'),'Large')) as Size;

Load * Inline [

Link_Product

G];

Load Link_Product, if(not Match(Link_Product, 'G'), 'Total') AS Size Resident Product;

Re: General Query

qlikviewwizard — Tue, 04 Aug 2015 06:06:26 GMT

Hi Mahamed Khan, Mayil Vahanan Ramasamy's solution is working for me.

Re: General Query

Mahamed_Qlik — Tue, 04 Aug 2015 06:08:04 GMT

I have one field named as Link_Products which contains 7 values (A,B,C,D,E,F,G) and further i want to categories it

in Small (A, B) Large (C,D,E) and Total (A,B,C,D,E,F) and this three categories should be in single field named as Products.

Thank you for your response.

Re: General Query

qlikviewwizard — Tue, 04 Aug 2015 06:17:24 GMT

Hi Use the below script: Here use Product for your requirement. Hope this will help you. Thank you.

Test:

LOAD *, if(Match(Link_Product, 'A', 'B'), 'Small', if(Match(Link_Product, 'C', 'D', 'E'), 'Large',if(Match(Link_Product, 'A', 'B''C', 'D', 'E'), 'Large'))) AS Product Inline

[

Link_Product

];

Load Link_Product,

if(not Match(Link_Product, 'G'), 'Total') AS Product

Resident Test;

Re: General Query

qlikviewwizard — Tue, 04 Aug 2015 07:22:50 GMT

Hi Mahamedfaijan

Did you get the solution?

Re: General Query

jagan — Tue, 04 Aug 2015 10:05:13 GMT

Hi Khan,

It is good practice to maintain the mapping details in an excel in the below format so that if there is any new Products/change in Type then it is easier to handle.

Product, Type

A, Small

B, Small

C, Large

D, Large

E, Large

Now load this data into Qlikview file, the mapping is done automatically.

Hope this helps you.

Regards,

Jagan.

Re: General Query

mightyqlikers — Tue, 04 Aug 2015 10:13:22 GMT

use below script

LOAD * INLINE [

Product, Link_Product

Small, A

Small, B

Large, C

Large, D

Large, E

Total, A

Total, B

Total, C

Total, D

Total, E

Total, F

, G

];

Re: General Query

qlikviewwizard — Wed, 05 Aug 2015 03:50:19 GMT

Hi Mahamedfaijan

Please close the thread by selecting Correct Answer. Thank You.