How to transform table A to table B (below)

[#1]

Hello!

Here's my data in a table format:

and I need to convert it to the below:

which basically shows the different combination of the first table and the counts.

And everytime I click on for example Y under c, all Y's in column c will be filtered accordingly.

Hope someone can help me on this Thank you!! Appreciate all the help I get from this community as I am indeed learning a lot! However for this one my mind is aching trying to even think of the correct term to describe this problem.

[Anil_Babu_Samineni]

May be transpose using Pivot Table Or Generic Load Statement also can work for you

[avinashelite]

Could you help me in understanding the data? you could share the sample data and explain

[beck_bakytbek]

Hi Joy,

look at this, i am sure that resolves your issue:

https://community.qlik.com/thread/246302

beck

[MarcoWedel]

Hi,

maybe one solution might be simply to use your existing a through d fields as dimensions and an expression like "count(item)" to get your required result?:

hope this helps

regards

Marco