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

[#1]

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

[#2]

Deepak Kurup wrote:
Can you attach the latest application with describing the problem.. I will check it and let u know asap<div></div>

I have already attached the sample application. Please look into it.

[#3]

Deepak Kurup wrote:
In DImensionn , below there will supress null value. please tick onn that.
Chekc your condition date <= vMaxDate . Equal to sign should be there. or check in VMaxDate what value you are getting. <div></div>

1. Supressed the null value but the result is same

2. Condition in the group is as same as you said:

=if(date >= '$(vMinDate)' and date <= '$(vMaxDate)',date)

3. vMaxDate is also same:

vMaxDate=Date(Max(date),'DD/MM/YYYY')

4. vMaxDate is showing 23/12/2011

I have checked all the above points but it is same as expected! Can you please look into the sample application.

[deepakk]

hi Attitude,

Change the vMaxDate to

vMaxDate = Date(max(Date) + 1, 'DD/MM/YYYY')

and the change the logic to date < vMaxDate.

[#5]

Hi Deepak

My question was when the same logic was working in yours then why it didn't work in my application. Although new logic is displaying the max(date) still there is one blank header after that. Only after supressing the null values it is not displaying that column. But thing is I want display all the data instead of supressing the null values. So that it displays all the rows with null values but blank which column which is there has to be ignored.

Any idea why is that happening? Please help me out when you are free.

[#6]

Hi Deepak

Using the below code I am displaying the background color inside the chart

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()))))))

I want to add below code which we are using in the dimension. Could you please guide me?

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

Thanks in advance!

[#7]

I tried something like below. But it didn't work! Could you please suggest me something on this...

IF(A1='Change1' ,lightgray(),
IF(A1='Change2',lightred(),
IF(A1='Change3',yellow(),
IF(A1='Change4',lightmagenta(),
IF(A1='Change5',lightcyan(),
IF(A1='Change6',lightblue(),
if(weekday(date) ='Sat' or weekday(date) ='Sun',Rgb(255,0,0),
green())))))))

[#8]

Hi Deepak

'Two Weeks' in the group works fine only when we don't select any dates field. But when I select any date field(Year: 2010) it is showing the repeatation of the date field. Could you please help me on this as well. I tried to resolve this issue what very sure what is causing the problem here. In the application which is attached previously if you select year:2010 you will see the repeatation of dates.

Please do reply

[deepakk]

hi Attitude,

the remaining value which doest not satisfy the condition of mindate and max date goes into null values, hence we need to suppress it.

in qlikview when ever u add filters in dimension then remaining values which does not satisfy the condition goes inside the null figure.

For color go to font color select the base color. now it provides you to different colors to select.

Select the color required, look below you will find Red, blue and green numbers for it.

use it in rgb(red,green,blue)

I hope this helps.

[#10]

This is understandable

Deepak Kurup wrote:
the remaining value which doest not satisfy the condition of mindate and max date goes into null values, hence we need to suppress it.
in qlikview when ever u add filters in dimension then remaining values which does not satisfy the condition goes inside the null figure.

This is not understandable! I am not sure what you are talking about.

Deepak Kurup wrote:
For color go to font color select the base color. now it provides you to different colors to select.
Select the color required, look below you will find Red, blue and green numbers for it.
use it in rgb(red,green,blue)
I hope this helps.

Can you please help me out in the below post which the same problem which was discussed here. It is little urgent! 😞

http://community.qlik.com/forums/t/44276.aspx

[deepakk]

For Light gray rgb(166,167,170) . see the attachment, you will come to know how i got the color