How to represent table in trellis style format??

[sushil353]

Hi All,

In the figure below i need to show table in this format in qlikview. tables are separated by there location. Clestica Monterry, Flextronics and wistron are the locations..

Please help me out to how would i able to show table like below format in qlikview... i am not able to find any clue..

Thanks.

[#2]

HI Sushil,

If you want this representation, you must choose the Pivot Table chart, and then select "Location", "Operation", "Test" and "Measurement" in dimensions.

Your expressions will be the "Total Quantity", "%Impact" and "%NDF, NDR".

Regards,

Amand

[sushil353]

but the main problem is with location.. which is out side of each sub table?

Thanks for your reply

[#4]

I think you must add a new table in the data model with your locations.

Can you attach your qvw file please ?

Regards,

Amand

[sushil353]

Please find the attached QVW.. i want to generate table separately for each location or selected locations

Thanks

[#6]

Sushil,

See the attached file. I make an example with the set analysis.

Regards,

Amand

[sushil353]

Hi Thanks Amand..

Is it possible to do it automaticaly... means instead of creating each table manually it will populate according to the selected location

[#8]

Sushil,

You can do this with a macro, which can generate your charts automatically. See the API Guide in your QlikView installation directory.

Why do you want this representation ? For a report ?

Regards,

Amand