Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have two Questions:
1. In Table, can we set background color which compare category by today and yesterday.
- If an activity is happen yesterday and today same activity background will change to red color.
- If an activity not happen yesterday and just happen today background will change to oren color.
2. It is possible when we click today date, it will show all today and yesterday activities. For yesterday it only show activity that happen only yesterday(that activity not happen today).
- If possible, that background will change green color.
Can anyone help me?
Regards,
Adam
Hi Adam,
Thanks for your questions. I will do my best to assist and others can gladly chime in.
I will first provide you with the help document to show you the cell shading conditional styling, when using Color By expression. Let us know if this is what you need for #1:
For #2 I will see if my colleague might have an idea. jpe - do you have an idea?
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to
Hi Adam,
Lets take your Concern One by One:
1. If I am sure you are using Qlik Sense, there is an application which comes by default Consumer Sales, Open it , go to the sheet Sales Analysis then click on the chart Sales By Rep and Customer =.Right Click => Unlink Visualization => Check the measure Sales => Check the back ground Color Expression , Try to replicate it with your desired color.
2. For date issue : Lets say Your dates are coming in DateFiled , So what you need to do create a variable where
set vPreviousday == day(today())-1
and create an expression like:
sum({<[DateFiled]={'$(vPreviousday)'}>} Amount)
Try to do it with your data. when you learn variables it will be very easy.
Read this very carefully once
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Rohit Kumar
Hi Michael and Rohit,
I already tried with your advice, but i still don't know how to create expression for :
- If an activity is happen yesterday and today same activity background will change to red color.
Example : Activity = Study
- If an activity not happen yesterday and just happen today background will change to oren color.
Example : Activity = Badminton
Here I attached with a qvf file.
Thanks,
Adam
Hi Adam - sorry for the delay I'm looking at this now
Here is a start - you put this in the Background Expression for the column you want to highlight.
I will look at the other expression next.
if (ActivityDate = Today() or ActivityDate = Today()-1,LightRed())
I created this app (attached) on a newer version of Qlik Sense as I am trying out some features, let me know if it works in your version. If not I will send you another file.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Regards,
Mike Tarallo
Qlik
I realize this is more involved then the example I sent you, looking into it further.
Hi Mike,
Sorry delay to inform you,. I already tried your app but it not like what i want.
In your app, all Activity background in table for today and yesterday will turn red with if (ActivityDate = Today() or ActivityDate = Today()-1,LightRed()) right?
What i want is,
1) If yesterday Activity and today Activity is the same activity, background will be red.
2) If today activity is new activity, the new activity will turn yellow background. i
Can i do it in qlik sense?
mto