topic Re: Need to highlight cells in Pivot Table (set analysis) in QlikView

Need to highlight cells in Pivot Table (set analysis)

Tue, 04 Nov 2014 02:18:32 GMT

Hi,

I need help with set analysis for my pivot table, please.

I have Effective Months = EFF_YYYYMM which is a dimension in pivot table above

ARCHIVE_DATE is also dimension in Pivot table

SUM(Bin_Distribution) is an expression with calculated numbers

I need to create set analysis inside "Visual Cues" for Bin Distribution

where number for Bin Distribution is compared to previous ARCHIVE_DATE (within the same EFF_YYYYMM) and it highlights if this number is less than original in yellow/red.

I enclosed excel file with some snapshots.

I appreciate your help very much.

Re: Need to highlight cells in Pivot Table (set analysis)

Tue, 04 Nov 2014 03:02:44 GMT

Dear Gennady,

You had better to introduced a conditional expression in the "Visual Cues" which will identifies the "True" or "False" of the condition. Then you can set the color accordingly.

Regards,

Priyantha.

Re: Need to highlight cells in Pivot Table (set analysis)

Tue, 04 Nov 2014 08:13:45 GMT

Dear Priyantha,

Thank you.

This is exactly what I am asking - I need to write set analysis formula into "Visual Cues", but not sure how to do it....