display 3 dates if i select one date

[khasimvali85]

urgent

[senpradip007]

Can you explain briefly or post a sample qvw?

[Anonymous]

Hi,

Please ellaborate more on what is your actual requirement....

Regards

Nitin

[khasimvali85]

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

[Anonymous]

Where do you want to display these dates??

If in text box , then please check attached file:

[jagan]

Hi,

Try this expression

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

Replace Date with you Date Dimension name.

Regards,

jagan.

[khasimvali85]

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

[khasimvali85]

Hi,

I Want to Display in Pivot Table

Thanks

Khasim

[Anonymous]

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

[jagan]

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.