Solved: show datavalues upto today - Qlik Community

Anonymous · ‎2015-02-20

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,

its_anandrjs · ‎2015-02-20

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

View solution in original post

sunny_talwar · ‎2015-02-20

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,

S

Report Inappropriate Content · ‎2015-02-20

Hi,

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

Anonymous · ‎2015-02-20

hi sunindia,

please find the sample application

its_anandrjs · ‎2015-02-20

Hi,

Then write SET expression as

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

Regards,

Anand

Report Inappropriate Content · ‎2015-02-20

please find the attachment.

its_anandrjs · ‎2015-02-20

Hi,

Check the attached solution file.

And write

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

Regards,

Anand

Anonymous · ‎2015-02-20

Hi Please find related Sample

Thanks in advance

maxgro · ‎2015-02-20

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

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

sunny_talwar · ‎2015-02-20

Here try this as your expression:

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

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

PFA the application also.

Best,

S