Problems with Pivot Table

Mon, 24 Mar 2014 19:29:18 GMT

Hello everyone,

I'm new here and this is my first post.

I started using Qlikview a month ago and I have a problem that I've been struggling since then.

I want to track the evolution of my products through time, so I created a crosstable with a "Pivot Table" chart:

But the calculation that I need to do for every month and product is:

Calculation = (Number of Units Sold/Customer Count)*100

So I used the following expression:

(SUM({<Measure = {'Number of Units Sold'}>} Value)/SUM({<Measure = {'Customer Count'},[Product Cod] = {'Products'}>} Value))*100

The only problem is that when I do this my "Pivot Table" goes blank.

My fact table is something like this:

I think the problem is that the "Pivot Table" searchs for the Customer Count for a specific product, when there is only Customer Count for the Product Cod "Products".

Hope someone can help me.

Thanks,

Danilo.

Re: Problems with Pivot Table

lironbaram — Mon, 24 Mar 2014 19:42:01 GMT

you can try to add total qualifier

so your expression will look like this

(SUM({<Measure = {'Number of Units Sold'}>} Value)/SUM({<Measure = {'Customer Count'}>} total <Month,Year> Value))*100

Re: Problems with Pivot Table

Mon, 24 Mar 2014 20:00:51 GMT

Thank you so much!!

You helped me a lot!

topic Re: Problems with Pivot Table in QlikView

Problems with Pivot Table

Re: Problems with Pivot Table

Re: Problems with Pivot Table