topic Re: How to Create Vriable for pivot table and i select one calender date display 3 previous dates in QlikView

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

khasimvali85 — Tue, 10 Jun 2014 09:39:50 GMT

Hi,

its Urgent

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

tresB — Tue, 10 Jun 2014 09:51:10 GMT

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

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

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

khasimvali85 — Tue, 10 Jun 2014 10:16:07 GMT

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.

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

tresB — Tue, 10 Jun 2014 10:19:14 GMT

Try to post your sample qvw.

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

ashfaq_haseeb — Tue, 10 Jun 2014 10:26:54 GMT

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

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

khasimvali85 — Tue, 10 Jun 2014 10:35:52 GMT

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.

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

ashfaq_haseeb — Tue, 10 Jun 2014 10:41:39 GMT

Hi,

The attached application does the same.

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

Regards

ASHFAQ

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

khasimvali85 — Tue, 10 Jun 2014 10:44:23 GMT

HI,

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

Thanks

Khasim.

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

khasimvali85 — Tue, 10 Jun 2014 16:16:57 GMT

Hi,

I am Sending Sample QVW File

Thanks

Khasim.

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

khasimvali85 — Tue, 10 Jun 2014 16:29:41 GMT

Hi,

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

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

ashfaq_haseeb — Tue, 10 Jun 2014 17:32:58 GMT

Hi,

When replying click on use advanced editor, as highlighted in the attached image.

Regards

ASHFAQ