Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how i can get analysis for purticular period(say 09/10/2005 to 08/12/2007)

how I can get analysis for a purticular period (say 09/10/2005 - 08/12/2007)

I am using 2 calendar object and I am not able to get different dates selected .

in two calendar object I have used orderdate as the field,so the moment I select 1 date in one calendar that particular date gets selected in other calendar as it is coming through same orderdate field.

I tried using resident concept,(by setting one field as orderdate and the second field as orderdate1 by using resident concept)

but that's not working.

please help

11 Replies
Not applicable
Author

please help

Not applicable
Author

hi.

Try using calender object and use that variable in ur chart to restrict the data for particular period.

regards

Shruti

Not applicable
Author

Create two new variables…


vStartDate and vEndDate

Now go to Settings – Document Properties – Triggers

Variable Event Triggers


Select vStartDate

OnChange Add Action

Add

Select in Field

Field = Your Date Field

Search String = ='>='&vStartDate & '<=' & vEndDate


Do the same for vEndDate


Now insert Input Box and add these two variables

Go to number tab and make sure that the formatting of vStartDate and vEndDate is same as your Date Field….


Hope this help

Not applicable
Author

can this be done using resident concept

Not applicable
Author

Hi,

U can do it by taking 2 island residents i.e Orderdate1 and orderdate2, which is same as variables.

So better to use variable method.

Can u please share ur detail req or test qvw??

-shruti

Not applicable
Author

yes I will share it right now

colin_albert

I have an example showing how two calendar objects will select a date range

http://community.qlik.com/docs/DOC-5598

kiranmanoharrode
Creator III
Creator III

Dear Sudhanshu,

               Just create few variables

     1) vMinDate = min(Date)

     2) vMaxDate =Max(Date)

     3) vMin = Calender Object Variable

     4) vmax = Calender Object variable

select VARIABLE and SINGLE Mode option in Calender Object.

for 1st calender Object

Select vMin as Variable

Min Value = vMinDate

Max Value =vMaxDate

for 2nd calender object

Select vMax as varible

Min Value = vMin

Max Value =vMaxDate

Use below expression in your chart

=Sum({<Date={">=(vMin)<=(vMax)"}>}Amount)

try this.................

for Further help post your sample application.........

Regards

Kiran Rode

+91 8976977897

Not applicable
Author

this is somewhat working for me..i have day ,year and month field,now if I select day field in field..then it just work for 31 days,month and year are left behind

what I want to do exactly is..i want to select the dates from my calendar objects and I want application to show me the analysis for that particular period .one calendar object is named FROM and the other one TO,

so how I can do it..plz help