topic Re: Re: display 3 dates if i select one date in QlikView

display 3 dates if i select one date

khasimvali85 — Mon, 09 Jun 2014 06:22:55 GMT

urgent

Re: display 3 dates if i select one date

senpradip007 — Mon, 09 Jun 2014 06:24:36 GMT

Can you explain briefly or post a sample qvw?

Re: display 3 dates if i select one date

Anonymous — Mon, 09 Jun 2014 06:30:41 GMT

Hi,

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

Regards

Nitin

Re: display 3 dates if i select one date

khasimvali85 — Mon, 09 Jun 2014 06:30:50 GMT

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

Anonymous — Mon, 09 Jun 2014 06:37:54 GMT

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

jagan — Mon, 09 Jun 2014 06:41:53 GMT

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

khasimvali85 — Mon, 09 Jun 2014 06:43:06 GMT

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

khasimvali85 — Mon, 09 Jun 2014 06:44:21 GMT

Hi,

I Want to Display in Pivot Table

Thanks

Khasim

Re: display 3 dates if i select one date

Anonymous — Mon, 09 Jun 2014 06:46:28 GMT

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

Re: display 3 dates if i select one date

jagan — Mon, 09 Jun 2014 06:47:18 GMT

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

Anonymous — Mon, 09 Jun 2014 06:48:42 GMT

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

khasimvali85 — Mon, 09 Jun 2014 06:49:40 GMT

Hi,

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

Thanks

Khasim.

Re: display 3 dates if i select one date

khasimvali85 — Mon, 09 Jun 2014 06:51:21 GMT

hi Dhiraj,

Where Should i Give the Expression?

Thanks

Khasim.

Re: display 3 dates if i select one date

jagan — Mon, 09 Jun 2014 06:53:47 GMT

Hi,

In Pivot table expression.

Regards,

Jagan.

Re: display 3 dates if i select one date

khasimvali85 — Mon, 09 Jun 2014 06:55:41 GMT

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: Re: display 3 dates if i select one date

jagan — Mon, 09 Jun 2014 06:56:07 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

Re: display 3 dates if i select one date

Anonymous — Mon, 09 Jun 2014 07:14:15 GMT

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.

Re: display 3 dates if i select one date

khasimvali85 — Mon, 09 Jun 2014 07:25:33 GMT

Hi Dhiraj,

I Tried Your Expression but Not Working you Given Expression

Thanks,

Khasim.

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

Anonymous — Mon, 09 Jun 2014 07:53:10 GMT

Hi Khasimvali,

Its working please check the attached file

Re: display 3 dates if i select one date

Mon, 09 Jun 2014 08:01:08 GMT

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