topic Re: Group on 2nd Dimension in Data table in QlikView

Group on 2nd Dimension in Data table

Wed, 06 Aug 2014 19:01:58 GMT

Hi,

Can anyone help me in grouping data on 2nd dimension to calculate contribution %..

I am not able to calculate contribution of "Category 1 & month April" in Apr month in a Pivot table.

When I put Total function in expression, I get contribution of "Category 1" in entire data table.

I am able to do it on excel but not able to do on QV, please help me with Expression or any other way of doing it.

My table looks like - I have attached excel file also where I am able to calculate the contribution.

Thanks,

Narsingh

joshabbott — Wed, 06 Aug 2014 19:12:59 GMT

Try this:

=sum(Count)/sum(TOTAL <Month> Count)

Attaching sample

ecolomer — Wed, 06 Aug 2014 19:32:48 GMT

See the fila attached

Wed, 06 Aug 2014 20:04:23 GMT

Thanks Josh & Enrique for you prompt responses!!

Sorry that I couldn't explain my problem correctly.

Excel which I sent, that is output of a QV pivot, In my data I have dates instead of Month and Categories are given but not count.

I am not able to use this formula because of dates and I want this pivot "Month wise".

Please help... Sample data is attached

Thanks,

Narsingh

joshabbott — Wed, 06 Aug 2014 20:07:20 GMT

Instead of the sum I supplied above, just use a 'Count'

=Count(Category)/count(Total <Category> Category)

joshabbott — Wed, 06 Aug 2014 20:10:23 GMT

example attached

Wed, 06 Aug 2014 20:17:00 GMT

Thanks Josh, Now I able to calculate!!!

This helped a lot

ecolomer — Wed, 06 Aug 2014 20:17:09 GMT

See the new file attached ...