topic Re: How to transform table A to table B (below) in QlikView

How to transform table A to table B (below)

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to transform table A to table B (below)

Anil_Babu_Samineni — Fri, 20 Jan 2017 06:21:10 GMT

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

Re: How to transform table A to table B (below)

avinashelite — Fri, 20 Jan 2017 06:24:38 GMT

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

Re: How to transform table A to table B (below)

beck_bakytbek — Fri, 20 Jan 2017 08:17:01 GMT

Hi Joy,

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

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

beck

Re: How to transform table A to table B (below)

MarcoWedel — Mon, 23 Jan 2017 22:55:39 GMT

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