topic Re: set analysis in QlikView

set analysis

Mon, 02 Feb 2015 11:07:50 GMT

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.

Re: set analysis

alexandros17 — Mon, 02 Feb 2015 11:17:42 GMT

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

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

let me know

Re: set analysis

maxgro — Mon, 02 Feb 2015 11:27:30 GMT

date is your date

val is the expression

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

Re: set analysis

Mon, 02 Feb 2015 11:41:27 GMT

Thanks for your reply.

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

suggest me pls

Thanks

Re: set analysis

alexandros17 — Mon, 02 Feb 2015 11:49:58 GMT

Does it works this ?

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

Re: set analysis

maxgro — Mon, 02 Feb 2015 11:56:50 GMT

see attachment

Re: set analysis

Mon, 02 Feb 2015 12:09:42 GMT

not working Saccone

Thanks

Re: set analysis

chematos — Mon, 02 Feb 2015 12:25:00 GMT

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