General Query

[Mahamed_Qlik]

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.

[jagan]

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.

[mightyqlikers]

HI

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

];

[qlikviewwizard]

Hi Mahamedfaijan

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