Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Month going across the top

I was trying get QV to do something similar to the image below but I am stumped. Any advise?

QV.PNG

10 Replies

Re: Month going across the top

Is this a pivot table?

How are you trying to get the month row?

Not applicable

Re: Month going across the top

Yes it is a pivot table.

Re: Month going across the top

Hi,

Check the Attachment.  May be helps..

Just used Pivot with the expression like

Sum(Aggr(sum(Sales)/sum(TOTAL Sales),Month,[Disposition Type]))


As per jontydkpi
Suggestion..

Sum(Sales)/sum(TOTAL <Month> Sales)

Capture.JPG

pradeepreddy
Valued Contributor II

Re: Month going across the top

Expression:

sum(Field_Name)/sum(total <Month>Field_Name)

Number Format: Fixed to 2 digits & show in %

MVP
MVP

Re: Month going across the top

You can simplify that expression:

Sum(Aggr(sum(Sales)/sum(TOTAL Sales),Month,[Disposition Type]))

to

Sum(Sales)/sum(TOTAL <Month> Sales)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Re: Month going across the top

Thank You jontydkpi

I will update the same in my attachment..

Not applicable

Re: Month going across the top

I got the expression part down but it is still not showing the months in each column. It looks like this right now;.qv2.PNG

Re: Month going across the top

Drag the "Lead Month" column heading to the upper right corner of the chart and drop it there.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Not applicable

Re: Month going across the top

works now. How can I sort it ascending by month?

Community Browser