Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

khasimvali85
Contributor II

display 3 dates if i select one date

urgent

1 Solution

Accepted Solutions
dhirajkumar
Contributor

Re: display 3 dates if i select one date

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.

21 Replies
senpradip007
Valued Contributor III

Re: display 3 dates if i select one date

Can you explain briefly or post a sample qvw?

gupta_n8
Valued Contributor II

Re: display 3 dates if i select one date

Hi,

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

Regards

Nitin

khasimvali85
Contributor II

Re: display 3 dates if i select one date

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


gupta_n8
Valued Contributor II

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

Where do you want to display these dates??

If in text box , then please check attached file:

MVP
MVP

Re: display 3 dates if i select one date

Hi,

Try this expression

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

Replace Date with you Date Dimension name.

Regards,

jagan.

khasimvali85
Contributor II

Re: display 3 dates if i select one date

30-May-1431-May-1401-Jun-14
TotalCustomersTotal %Total CustomersTotal %TotalCustomersTotal %
1106Rajendra0.40%1051Ravi0.50%1101Sekhar3.10%
1811Raja8.50%1718Rajesh2.00%1716Siva2.70%

I Want to disply like above Table by using Set Analysis and Variables

khasimvali85
Contributor II

Re: display 3 dates if i select one date

Hi,

I Want to Display in Pivot Table

Thanks

Khasim

gupta_n8
Valued Contributor II

Re: display 3 dates if i select one date

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

MVP
MVP

Re: display 3 dates if i select one date

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.

Community Browser