Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be transpose using Pivot Table Or Generic Load Statement also can work for you
Could you help me in understanding the data? you could share the sample data and explain
Hi Joy,
look at this, i am sure that resolves your issue:
https://community.qlik.com/thread/246302
beck
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