topic Re: till date in QlikView

till date

Tue, 18 Jun 2013 06:07:10 GMT

i hav a date column, i want user to select a date and the records to be shown till tht date,

object can be a chart

and

also a table box.

Re: till date

sujeetsingh — Tue, 18 Jun 2013 06:10:53 GMT

In chart you can implement it with if() case statement or set analysis but can not in Table Box.

See this example

Re: till date

Tue, 18 Jun 2013 06:14:07 GMT

example is misssing

Re: till date

sujeetsingh — Tue, 18 Jun 2013 06:17:16 GMT

Sorry for that ,

now it is there.

Re: till date

Tue, 18 Jun 2013 06:35:51 GMT

Please try below this expression.

{<Year={$(vMaxYear)},MonthOrder={"<=$(=Max({<Year={$(vMaxYear)}>}MonthOrder))"}>}

vMaxYear = Max Date Year(Variable)

Create a field in time dimension 'MonthOrder'

MonthOrder like 1,2,3...12

MonthOrder field u will get from Month(If Month=Jan,1,If Month=Feb,2 Like.....)

Regards-Bika

Re: till date

Tue, 18 Jun 2013 06:40:03 GMT

hey date selection is giving me sum of tht date,

i need till tht date,

if i select 12/11/2010, sum shld come 18

Re: till date

Tue, 18 Jun 2013 07:17:36 GMT

You need to keep master calender with all date for selction

Find the attachment.. it may help you

Karthik

Re: till date

Tue, 18 Jun 2013 07:17:47 GMT

bika,

Ur exp is not working

Re: till date

Tue, 18 Jun 2013 07:29:15 GMT

Thanks Karthik,

bt its nt working, whn i select other dates frm calender mismatch occurs...

Re: till date

Tue, 18 Jun 2013 08:24:06 GMT

Could you explain little more..

It look like ok for me.

Please give feedback with example value..

Re: till date

Lee_Matthews — Tue, 18 Jun 2013 08:31:56 GMT

Setup a variable called vFilterDate. Add a calendar object that uses the variable. Then try something like this as your expression (assuming ShipDate is the field you want to display):

=if(ShipDate-$(vFilterDate)>0, ShipDate-$(vFilterDate), null())

The key thing is you want nulls to result in the expression for dates that dont meet the condition. Then the chart ignores them by default, leaving only th edata you want to display.

Re: till date

Tue, 18 Jun 2013 08:32:14 GMT

in the example, i hav selected dec12, according to table box i shld get 14 as o/p

bt frm ur expression its showing 18

Re: till date

Tue, 18 Jun 2013 08:59:31 GMT

Still i ddin't understand Prashant..

In my table I have data for

12th Feb is 6

12th Oct is 8

12th Nov is 4

12th Dec is 2

So If you are selecting 10th December , It will show 18 (6+8+4).

If you select 12th December, it will show 20 (6+8+4+2).

Note: I am using DD/MM/YYYY format...

Regards,

Karthik

Re: till date

Tue, 18 Jun 2013 09:13:07 GMT

O yes the problem ws with the format, so mistaken....

working the same approach in the main application,

can u send me the application frm the calender qvd is generated.

thanks a lot...

Re: till date

Tue, 18 Jun 2013 09:22:09 GMT

Prashant,

Find attachment.

Please mark Correct answer, that will help other developers like us..

Karthik