Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Percent through the month/quarter

I need help with calculating the percent through the month and quarter in a couple of different views.

The first is a straight text box that will display the percent through the quarter.

The second is for conditional formatting. I have a pivot table with each month's performance compared to budget. I would to have conditional formatting for the percent through the month for each month. Therefore, since March is 100% over, anything over 100% is green. However May is only 3% through the month therefore anything over 3% would be green.

Thanks for your help!

Community Browser