topic COMPARE TWO DIFFERENT PERIODS in QlikView

COMPARE TWO DIFFERENT PERIODS

dr_zanusso — Mon, 17 May 2010 14:11:14 GMT

Hello , i'm a new entry and i'm trying to make some analisys with the personal edition

I need to know

first : how to create 4 input field with 4 different dates to compare the first period with the second period

second : how to create two different input boxes in witch i write the number of working days of the first and the second period

third: how to compare (amount of orders)/(first working days) from first start date to first end date WITH (amount of orders)/(second working days) from second start date to second end date

thank's for your reply

COMPARE TWO DIFFERENT PERIODS

Fri, 22 Oct 2010 07:41:01 GMT

Hello Dr. Zanusso,

i have got the same problem and looking for a solution.

Could you solve that problem and would you like to share the solution with me?

Thanks for your reply

COMPARE TWO DIFFERENT PERIODS

Fri, 22 Oct 2010 08:46:41 GMT

Hi Dr. Zanusso,

you can create input objects (use right click on your current sheet). In the dailog you can create the necessary variable (and an intial input, if you like). I build a little application to show you a first direction. Look into the expression of the two (blue) text objects to get an idea how to work with dates. i.e. the "networkdays(vDate1,vDate2)"

For more details refer to your online-help/manual.

Take a glance at my app.

Third question: Don't you have any input data to load. I did load two exam fields directly.To compare i.e. amount of orders I suggest you to create a chart object.

regards

Roland