Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding a Field in a Group(Cyclic) to display latest two weeks

Hi

In one of my pivot table I have a group called as Time. Which contains fields such as =Week(date),=Year(date),=WeekName(date) and =MonthName(date). With that I want to one more fields which calculates only 2 weeks of data. It should show latest 2 weeks date only.

I tried something like =Date(Max(date)-14) but it didn't work.

Can some one help me out on this please.

Thanks

Rikeb

43 Replies
Not applicable
Author


Deepak Kurup wrote:
For Light gray rgb(166,167,170) . see the attachment, you will come to know how i got the color<div></div>


Smile I didn't asked anywhere for the color. It seems I confused you becuase of lots of post here.

What I might have asked is...

This is what I am using in the Properties --> Expressions --> Date(Field) --> Background Color --> Below code:

With that as you said I need to add this. I tried that in different way as show in my above post but it is not working as expected.

=if(weekday(date) ='Sat'or weekday(date) ='Sun',Rgb(255,0,0))




IF(A1='Change1' ,lightgray(),
IF(A1='Change2',lightred(),
IF(A1='Change3',yellow(),
IF(A1='Change4',lightmagenta(),
IF(A1='Change5',lightcyan(),
IF(A1='Change6',lightblue(),
green()))))))


If anything is not understandable please do let me know

Not applicable
Author

Hi Deepak

To tell you in short in the attached application I want to add below code which you had given to the 'color' variable. Color variable is used in Properties --> Date --> Background Color. Can you please add your code to the color variable so that background color of weekends are in red along with the other condition.


=if(weekday(date) ='Sat'or weekday(date) ='Sun',Rgb(255,0,0))


color(Variable):


IF(A3='Approved' ,lightmagenta(),
IF(A3='Completed',Yellow(),
IF(A3='Implemented',cyan(),
IF(A3='In Progress',Green(),
IF(A3='Pending Approval',lightblue(),
IF(A3='Registered',Blue(),
IF(A3='Risk and Impact',darkgray(),
IF(A3='To Be Approved',lightgreen(),
lightmagenta()))))))))


deepakk
Partner - Specialist III
Partner - Specialist III

hi,

sorry i didnt get it..

Not applicable
Author

In the attached application

Goto: Settings --> Variable Overview --> Color

I using this variable(color) in the (Goto: Properties --> Expression --> Date --> Background color). This variable displays the background color according to the A3(Status). Along with this condition I want to display background color as red for weekends.

Hope it is understandable now! If not please do let me know. I will put it in someother way...



deepakk
Partner - Specialist III
Partner - Specialist III

hi,

Check out the attachment. Is this what you are looking for.

Not applicable
Author

Sorry this is not the one I asked for. What you did is you have removed $(color) from the background. What I need is background color should be displayed based on the condition in the variable along with below condtion.


=if(weekday(date) ='Sun'or weekday(date) ='Sun',Rgb(255,0,0))


I tried something like below but it didn't work:


IF(A3='Approved' ,lightmagenta(),
IF(A3='Completed',Yellow(),
IF(A3='Implemented',cyan(),
IF(A3='In Progress',Green(),
IF(A3='Pending Approval',lightblue(),
IF(A3='Registered',Blue(),
IF(A3='Risk and Impact',darkgray(),
IF(A3='To Be Approved',lightgreen(),
if(weekday(date) ='Sun'or weekday(date) ='Sun',Rgb(255,0,0),
lightmagenta())))))))))


Hope it is understandable now [:'(]

deepakk
Partner - Specialist III
Partner - Specialist III

hi Attitude,

See my attachment above . I have use only keyword and its working fine

if(only(weekday(date))= 'Sun',rgb(255,0,0))

Not applicable
Author


Deepak Kurup wrote:
See my attachment above . I have use only keyword and its working fine
if(only(weekday(date))= 'Sun',rgb(255,0,0))<div></div>


But in the above attachment you have removed the variable(color) from the value(expression tab) background and you are using only the above code. But where what I need is I want to use variable 'color' along with the above code. I think you didn't see the variable yet that's why the confusion is.

Please look into it and help me out. It is little urgent!

deepakk
Partner - Specialist III
Partner - Specialist III

Try this application

Not applicable
Author

Hi Deepak

The application which you have attached is not working. Below code has done the trick!


if(only(weekday(date))='Sat' or only(weekday(date))='Sun',rgb(255,0,0),
IF(A3='Approved' ,lightmagenta(),
IF(A3='Completed',Yellow(),
IF(A3='Implemented',cyan(),
IF(A3='In Progress',Green(),
IF(A3='Pending Approval',lightblue(),
IF(A3='Registered',Blue(),
IF(A3='Risk and Impact',darkgray(),
IF(A3='To Be Approved',lightgreen(),
lightmagenta()))))))))