Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 

Background Color Pivot Table in Saas


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