Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
urgent
Hi Khasimvali,
according to your output which you want follow the below instructions-
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.
Can you explain briefly or post a sample qvw?
Hi,
Please ellaborate more on what is your actual requirement....
Regards
Nitin
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
Where do you want to display these dates??
If in text box , then please check attached file:
Hi,
Try this expression
=Concat({<Date={'>=$(=Date(Max(Date)-2))<=$(=Date(Max(Date)))'}>} Date, '|')
Replace Date with you Date Dimension name.
Regards,
jagan.
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
Hi,
I Want to Display in Pivot Table
Thanks
Khasim
Please post a sample appliction so that solution can be easily provided.
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.