topic Re: show datavalues upto today in QlikView

show datavalues upto today

Anonymous — Fri, 20 Feb 2015 18:04:43 GMT

i have date field and Actual values

here i want to show only data Upto Today() means Feb-15. Cutoff the values after feb-2015.

how to write this in set analysis

i need this in front end only

Thanks,

Re: show datavalues upto today

sunny_talwar — Fri, 20 Feb 2015 18:09:27 GMT

May be like this:

Sum({<Date = {'<= $(=Date(Today(), 'yourDateFormat')'}>} [Actual Site Activation])

You will need to make sure that the format of the yourDateFormat matches the format of Date in your database.

HTH

Best,

Re: show datavalues upto today

Fri, 20 Feb 2015 18:09:33 GMT

Hi,

You can use where function inside where use month function to pick current month.

Re: show datavalues upto today

Anonymous — Fri, 20 Feb 2015 18:22:34 GMT

hi sunindia,

please find the sample application

Re: show datavalues upto today

its_anandrjs — Fri, 20 Feb 2015 18:28:19 GMT

Hi,

Then write SET expression as

=Sum({$<DateField = {'<=$(=(Today()))'}>} [Actual Site Activation])

Regards,

Anand

Re: show datavalues upto today

Fri, 20 Feb 2015 18:29:22 GMT

please find the attachment.

Re: show datavalues upto today

its_anandrjs — Fri, 20 Feb 2015 18:32:05 GMT

Hi,

Check the attached solution file.

And write

=Sum({$<Actual = {'<=$(=(Today()))'}>} value)

Regards,

Anand

Re: show datavalues upto today

Anonymous — Fri, 20 Feb 2015 18:43:50 GMT

Hi Please find related Sample

Thanks in advance

Re: show datavalues upto today

maxgro — Fri, 20 Feb 2015 18:47:33 GMT

if you want to include date until end of month, feb-2015

=Sum({$<Actual = {"<=$(=(MonthEnd(Today())))"}>} value)

Re: show datavalues upto today

sunny_talwar — Fri, 20 Feb 2015 18:49:50 GMT

Here try this as your expression:

=Sum({<Actual = {'<=$(vToday)'}>} value)

here vToday =Date(Today(), 'M/D/YYYY')

PFA the application also.

Best,

Re: show datavalues upto today

Anonymous — Fri, 20 Feb 2015 18:51:43 GMT

Hi Massimo,

still no luck,,

Please find the above Sample application

Thanks for your time

Re: show datavalues upto today

maxgro — Fri, 20 Feb 2015 18:58:52 GMT

replace the values in Date field with date

example

load * inline [

Date, Actual Site Activation

3/15/2015,10

2/15/2015,20

1/15/2015,2

4/15/2015,30

];

in chart

=Sum({$<Date = {"<=$(=(MonthEnd(Today())))"}>} [Actual Site Activation])

Re: show datavalues upto today

its_anandrjs — Fri, 20 Feb 2015 19:09:44 GMT

Hi,

It is better you use date format in the script and then use in the chart

Ex:-

T1:

LOAD Date,

[Actual Site Activation]

FROM

j1.xlsx.xls

(biff, embedded labels, table is Sheet1$);

NoConcatenate

LOAD

Date(date#(Date,'MMM-YY'),'MMM-YY') as DateField,

[Actual Site Activation]

Resident T1;

DROP Table T1;

And in charts

Dim:- DateField

Expre:- =Sum({$<DateField = {'<=$(=(Date(MonthName(Today()),'MMM-YY')))'}>} [Actual Site Activation])

Regards,

Anand

Re: show datavalues upto today

Fri, 20 Feb 2015 19:15:07 GMT

Hi,

I have attached a qvw file for you in previous post and that is working fine