Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

set analysis

Hi to all,

I have my data with start date is 01/12/2008.

if i  select at date 2/2/2014 in List box,i want display the data from 01/12/2008 to 2/2/2014.   [in pivot table]

Please suggest me..

Thanks in Advance

chandra.

7 Replies

Re: set analysis

In your pivot table add to all your expressions a set analysis, somthing like:

Sum({$ < myDate={'$(=GetFieldSelections(myDate))'}> } Values)

let me know

MVP
MVP

Re: set analysis

date is your date

val is the expression

sum({$ <date={"<=$(=max(date))"}>} val)

Not applicable

Re: set analysis

Hi

Thanks for your reply.

But i Want to get the data from starting date  to selected date.

suggest me pls

Thanks

Re: set analysis

Does it works this ?

Sum({$ < myDate={'<=$(=GetFieldSelections(myDate))'}> } Values)

MVP
MVP

Re: set analysis

see attachment

Not applicable

Re: set analysis

Hi

not working Saccone

Thanks

chematos
Valued Contributor II

Re: set analysis

Hi,

I recommend you to create a table only with date fields, unlinked to the model, a DataIsland, e.g. if you have a Calnedar table with a date filed (Date) and a date field with number format (NumDate), I recommend to use number format to compare dates:

Qualify *;

Dates:

Load distinct Date,

     NumDate

from Calendar;

Unqualify *;

Remind to have the same date format in both tables, then you can use Dates.Date as the date filter in your dashboard and use something like this in your chart:

Sum({<NumDate={<=Dates.NumDate}> } data)


Please. review the syntaxis.


Regards,

Jose

Community Browser