21 Replies Latest reply: Jun 12, 2014 2:05 AM by khasimvali shaik

# display 3 dates if i select one date

urgent

• ###### Re: display 3 dates if i select one date

Can you explain briefly or post a sample qvw?

• ###### Re: display 3 dates if i select one date

I Have Date Field like ComplaintDate by using Date field if i select One Date i want to disply previous 3 dates at a time

EX: i want to select today date 09/06/2014

Execution:

06/06/2014  |  07/06/2014   |  08/06/2014

• ###### Re: Re: display 3 dates if i select one date

Where do you want to display these dates??

If in text box , then please check attached file:

• ###### Re: display 3 dates if i select one date

Hi,

Try this expression

=Concat({<Date={'>=\$(=Date(Max(Date)-2))<=\$(=Date(Max(Date)))'}>} Date, '|')

Replace Date with you Date Dimension name.

Regards,

jagan.

• ###### Re: display 3 dates if i select one date

Hi,

Where Should i Give that Expression? in Variable or pivot table

Thanks

Khasim.

• ###### Re: display 3 dates if i select one date

Hi,

Regards

Nitin

• ###### Re: display 3 dates if i select one date
 30-May-14 31-May-14 01-Jun-14 Total Customers Total % Total Customers Total % Total Customers Total % 1106 Rajendra 0.40% 1051 Ravi 0.50% 1101 Sekhar 3.10% 1811 Raja 8.50% 1718 Rajesh 2.00% 1716 Siva 2.70%

I Want to disply like above Table by using Set Analysis and Variables

• ###### Re: display 3 dates if i select one date

Hi,

I Want to Display in Pivot Table

Thanks

Khasim

• ###### Re: display 3 dates if i select one date

Hi,

Use this set analysis in your expressions

{<Date={'>=\$(=Date(Max(Date)-2))<=\$(=Date(Max(Date)))'}>}

Ex: Sum({<Date={'>=\$(=Date(Max(Date)-2))<=\$(=Date(Max(Date)))'}>} Total )

Hope this helps you.

Regards,

Jagan.

• ###### Re: display 3 dates if i select one date

Please post a sample appliction so that solution can be easily provided.

• ###### Re: display 3 dates if i select one date

Hi Khasimvali,

as of your requirement this method is working

=date(Max(datefield)-1,'DD-MM-YYYY')

=date(Max(datefield)-2,'DD-MM-YYYY')

=date(Max(datefield)-3,'DD-MM-YYYY')

use three text box and use this expression.

I think this would be helpful for you...

• ###### Re: display 3 dates if i select one date

hi Dhiraj,

Where Should i Give the Expression?

Thanks

Khasim.

• ###### Re: display 3 dates if i select one date

Hi,

In Pivot table expression.

Regards,

Jagan.

• ###### Re: Re: display 3 dates if i select one date

Hi,

Please find attached file for solution.

Regards,

Jagan.

• ###### Re: display 3 dates if i select one date

Hi Dhiraj,

I Want this requiremeni in Pivot Table Only given below

on the top of Slide/ Calender Object Need if i Select Date in  Calender i want to display given Pivot Table

i Have created created Calender also.

 30-May-14 31-May-14 01-Jun-14 Total Customers Total % Total Customers Total % Total Customers Total % 1106 Rajendra 0.40% 1051 Ravi 0.50% 1101 Sekhar 3.10% 1811 Raja 8.50% 1718 Rajesh 2.00% 1716 Siva 2.70%

Thanks

Khasim.

• ###### Re: display 3 dates if i select one date

Hi Khasimvali,

use date field and other field also in dimention  which you want to display in pivot table then in expression use this set analysis

Sum({<SaleDate={'>=\$(=Date(Max(SaleDate)-3))<=\$(=Date(Max(SaleDate)-1))'}>} Data )

in  place of SaleDate use your datefield .

Hope this would be helpful for you.

• ###### Re: display 3 dates if i select one date

Hi Dhiraj,

Thanks Your Suggession, The Expression is  Working

but i need dynamiclly select Calender date automatically change the dates.

any idea?

Thanks

Khasim.

• ###### Re: display 3 dates if i select one date

Hi Dhiraj,

Its Working Good, I Applied Variable in This Expression Working Awesome.

Thanks Giving me Suggession.

Thanks

Khasim.

• ###### Re: display 3 dates if i select one date

Hi Dhiraj,

I Tried Your Expression but Not Working you Given Expression

Thanks,

Khasim.

• ###### Re: Re: display 3 dates if i select one date

Hi Khasimvali,

Its working please check the attached file

• ###### Re: display 3 dates if i select one date

Hi ,

Just a thought, Can we use triggers here ?

Like when getselectedcount(Date) = 1 then select field setexpression (two days back)

Thanks & Regards

Suhas Gupta