Format mutliple dimensions

[george55]

Would like to use background formating formula in a pivot. It works fine with one formula, but how can use multiple formating formulas? Tried to separate them with ";", with "," but did not work. 

If(Dimensionality()=1 AND $(v1) >= 100, Red());
If(Dimensionality()=2 AND $(v1) >= 10, Rgb(255, 130, 171));

[sunny_talwar · Accepted solution]

Try nested if statement

If(Dimensionality() = 1 and $(v1) >= 100, Red(),
If(Dimensionality() = 2 and $(v1) >= 10, Rgb(255, 130, 171)))

[george55]

Thanks it works.

Additional question: Is it possible to use a colour-trend like in Excel on a dimension-level?

[sunny_talwar]

I believe so...

[george55]

and how can I do it? 🙂

[sunny_talwar]

I am not sure what you are doing in Excel and what do you have in Qlik Sense.. are you able to share your Excel and Qlik Sense document to see what you have?

[george55]

See my pivottable in the picture above. The colours I have done with the nested Dimension() formula. So I put the "borders" by hand, e.g.: If(Dimensionality()=1 AND $(vXIM_A_Team) >= 1000, Red(). 

Look first line "Jan" or "Feb" (Dimension 1), there you have numbers: 1169, 1440, 651, 454, 611, 756, 842. This is the month dimension. What I want: the cells should be formated according to their number from a range (max - min) and associated with colours: max: very red, and min very green. Between the colours should change gradualy changing from red to green. And this on a dimension-level.

[sunny_talwar]

May be use an extension for this -> Qlik Sense Extension 2 Dimensional Heatmap 

[george55]

thanks, will take a lock.