Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
JanM1711
Contributor
Contributor

Conditional Formatting in Pivot table

Dear all,

i want to use a conditional formatting on the font color in a Pivot table.

The Pivot table got two dimensions actual delivery date and planned delivery date and the measure is quantity.

The date fields should be shown as month and if the the month of actual delivery date is greater than the planner delivery date the measure should be shown in red.

Everything works fine, when i do this on calday. But it doesnt work for month.

I generated the month by using num(month(date datefield)) and it shows me the number of the month. But the font color does not fit.

Do i have to group the measure also on a monthly base within the measure?

Thanks for your help.

Regards Jan

Labels (1)
1 Reply
sidhiq91
Specialist II
Specialist II

@JanM1711  Could you please provide us some sample data and the expected output so that we can figure out some solution for it?