How to color format the cells in the pivot table

[Ramya]

Hi everyone,

i am new to qliksense development

i am working on building the pivot table in qliksense.

My req is to change the color of the cells based on the condition if(job_status='SUCCEEDED',green()(if(job_status='Failed',red(), Yellow()))

i am unable to find any options for background color change as like in qlik view.

Here i am attaching the sample data and desired output format in excel.

can any one help me to achieve this.

[tomovangel]

Hello Ramya,

Qlik Sense can change color of the text as we ll as on the background but only on Measures( this are calculations). 

and also, your expression is wrong, it has to be like this for qliksense to read it correctly:

if(job_status='SUCCEEDED',green(),
if(job_status='Failed',red(), Yellow()))

Hope I helped, 

BR,

Ace

[Ramya]

Hi ,

Thanks for the response. i have corrected the expression.

i have implemented the color logic in background color.

But my challenge is now i used =1(dummy) as measure just to have as i have implemented the logic for color.

Now i want to hide the 1 in the cells.

how can i achieve this.

[Ramya]

Hi,

Achieved it by copying the same expr in text.

Thanks

[tomovangel · Accepted solution]

Hi, Im glad I helped, you can actually get more cool colors, by using the following expression instead of Red()

RGB(255,0,0) this is red colour 

rgb(255,15,15) this is little redder 

I am saying this to you because sometimes you may need to have 2 different red or Green colours 🙂 
Please mark the answer as correct, so others know that this is answered 

[Ramya]

Hi,

Thank you for the response.

i need one more help here.

Here i need to achieve the following condition  for the pivot table . whenever the app opens i.e, the default selection

Default rolling month: today's date - 31 days

   Example: Feb 6 - Jan 6

                   Feb 7 - Jan 7

If the user  deselects the above default selection then the complete data should display for the pivot table.

Here i am attaching the qvf.

Thanks.

Ramya.