topic Re: Migration Chart in QlikView

Migration Chart

erikzions — Wed, 16 Oct 2013 19:47:42 GMT

I am trying to make a migration table similar to the one below.

	Low	Med	High	Total
Low	1	5	1	7
Med	3	1	2	6
High	1	1	1	3
Total	5	7	4

I have everything working except for being able to make it a percent of the total. Becuase I am using calculated dimensions I cannot use count(total <dimension> Key). I can't think of a way to accomplish this another way.

Attached is a mockup of what I am trying to do. If anyone can help that would we wonderful.

Re: Migration Chart

swuehl — Wed, 16 Oct 2013 22:03:57 GMT

Hm, maybe like attached?

Re: Migration Chart

erikzions — Thu, 17 Oct 2013 14:41:21 GMT

That looks like the solution. It is acting funny in my app though (random nulls). I will have to figure that out.

(edit) Min works better than only becuase there can be more than one result. Though I never would have gotten this far without you.

Thanks swuehl.