Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
alexandros17
Partner - Champion III
Partner - Champion III

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

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

let me know

maxgro
MVP
MVP

date is your date

val is the expression

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

Not applicable
Author

Hi

Thanks for your reply.

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

suggest me pls

Thanks

alexandros17
Partner - Champion III
Partner - Champion III

Does it works this ?

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

maxgro
MVP
MVP

see attachment

Not applicable
Author

Hi

not working Saccone

Thanks

chematos
Specialist II
Specialist II

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