Re: Column Name as dimension label - Qlik Community

Anonymous · ‎2016-06-21

I am trying to build a grid chart for below data set

(1=person has the product, 0 = Not have the product)

-------------------------------------------------------------------------------------------------------------------------------------------------------------------

Person id Product1 Product2 Product3 Product4 Product5

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

A 1 0 0 1 0

B 1 0 1 0 0

C 0 0 1 0 1

D 0 1 0 1 0

E 0 0 1 0 0

F 1 1 0 1 0

------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Now the requirement is to create a cross product analysis in grid chart to display how many persons holds the products. Can someone help me to create the products as dimension in the grid chart?

Let me know if I am not very clear with my question. Thanks for the help!!

Best Regards,

JS

oknotsen · ‎2016-06-21

Hi,

Could you tell us for which product this question is; QlikView or Qlik Sense?

Based on your answer we will move your question to the right section.

Thanks.

May you live in interesting times!

Anonymous · ‎2016-06-21

It is for QlikView, Forget to mentioned that

oknotsen · ‎2016-06-21

Topic now moved to "New to QlikView".

May you live in interesting times!

muthukumar77 · ‎2016-06-21

Hi,

Refer this app,

Muthukumar Pandiyan

Anonymous · ‎2016-06-21

Thanks for the reply MuthuKumar!!

But I am looking for something like below and I have 200+ million person id against 20 products

sunny_talwar · ‎2016-06-21

Like this?

Used muthukumar77‌'s sample to create this using Grid Chart