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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
LaWi
Partner - Contributor
Partner - Contributor

Background Color Pivot Table in Saas

Hi,

I have an issue with the Background color in a Pivot Table in Saas  and cannot figure out if its a bug or not.

Im using WeekDay as my first dimension and YearWeek as second. Measure is Sum of Sales 4 weeks back, see attachment.
I only want to color the Total row on my first dimension WeekDay so i use the following if-statement:

if((rowno()=0 and ColumnNo()<>0 and

Sum({1<Currency = {'$(=Currency)'}, $(vIgnoreDateSelections), Key_Date = {">=$(=WeekStart (Date(Today () - 21)))<=$(=Today ())"}>}Sales) > x, etc

This works as long as Im have field Year selected to current year. As soon as i change field Year to anything else will get the background colored for RowNo() = 0 and ColumnNo = 0.

Is it wrong of me to assume that the Totals RowNo() and ColumnNo() is always 0? 

Labels (1)
  • SaaS

0 Replies