How to Create Vriable for pivot table and i select one calender date display 3 previous dates

[khasimvali85]

Hi,

its Urgent

[tresesco]

Say your expression in pivot table is like: Sum(Sales). Then rewrite it like:

Sum({<DateField={">=$(=Date(Max(DateField)-2)) <=$(=Date(Max(DateField)))"}>}Sales)

[khasimvali85]

Hi,

Thanks your Suggession

But Using variable i want to select Calender date,

EX: i wanna select One Date from Calender Date Like 02/06/2014 (This is Calender Object)

My OutPut Is:  wanna display Previous 3 dates In Pivot Tavle

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%
Total			2769			2817

Thanks

Khasim.

[tresesco]

Try to post your sample qvw.

[ashfaq_haseeb]

Hi.

This question was answered here.

http://community.qlik.com/thread/121220

and here

http://community.qlik.com/thread/121357

try not to duplicate content.

If you can share sample app with required output it would be better.

hope it helped.

Regards

ASHFAQ

[khasimvali85]

Hi ,

Previous 3 dates Showing But i Need Using Variables

I wanna select One date Dinamically, show previous 3 dates will show above i given table Like.

My system no rights to add Any Application.

Thanks

Khasim.

[ashfaq_haseeb]

Hi,

The attached application does the same.

Do one thing go home today and attach your sample app.

Regards

ASHFAQ

[khasimvali85]

HI,

Sure i will Send i have created one Sample Application in my lap.

Thanks

Khasim.

[khasimvali85]

Hi,

I am Sending Sample QVW File

Thanks

Khasim.

[khasimvali85]

Hi,

Where is the option to upload a file, i am not able to see.