topic Re: date Upto in QlikView

date Upto

Fri, 07 Jun 2013 08:23:19 GMT

I have 6 tables with a common calender,

morely i hav combined another calender and made duedate,

nw the user wants to see the data as if date upto the duedate,

tht means, user wants to see the records till date selected frm the list box of due date,

hw can i do tht.

Re: date Upto

Fri, 07 Jun 2013 09:08:42 GMT

Some suggestions pls

Re: date Upto

Fri, 07 Jun 2013 10:13:36 GMT

i simplify it again,

i have a duedate column,

i want the user to get the privilege of selecting the date, which will be taken as a limit,

then the corresponding chart to show the records till the date selected by the user

i tried by using input box but it didn happend, dates are not getting visible in input box

Please someone help

Re: date Upto

Fri, 07 Jun 2013 11:15:56 GMT

Pls follow the application,

Re: date Upto

Tue, 11 Jun 2013 04:32:22 GMT

Hey Mohit,

Thnks for the reply and thnks for the shared app
but tht is not serving my requirement,
i have already defined the calender and using it successfully in 6 other sheets designed
wht the user wants is, thr r 2 more cols. D_Date and Actiondate
the user wants to club both the dates and call it as duedate,
and he wants to select the duedate, so tht the whole chart shld show the records till tht date

hw can i do tht...

Please help me out,
m sending the updated excel sheet....

Re: date Upto

Tue, 11 Jun 2013 04:58:55 GMT

Anybody pls, m stuck in this issue frm a very long time............

Re: date Upto

Tue, 11 Jun 2013 06:04:26 GMT

am totally clueless on this .

Gurus any help on this ????/

Re: date Upto

amars — Tue, 11 Jun 2013 06:47:12 GMT

Check attached file.

Re: date Upto

Tue, 11 Jun 2013 07:34:10 GMT

Thanks Amar,

whn i select other dates, o/p is nt coming....

Re: date Upto

amars — Tue, 11 Jun 2013 08:52:20 GMT

Change the expression to

=Count(Distinct If([Mfd date]<Date#(Inputdate),[P Id]))

Thanks

Re: date Upto

Tue, 11 Jun 2013 11:56:38 GMT

hey amar,

can u jst lt me knw, wht hav u put in the variables

Inputdate variable

vMaxdate variable

vMinDate variable

pls let me know...

m trying to do the same thing in live application and its not taking the dates....