topic Re: Set Analysis to make the date selection base on anther Date Field in QlikView

Set Analysis to make the date selection base on anther Date Field

Fri, 07 Oct 2011 02:39:58 GMT

In my example , these is Column SDate and EDate and the dashboard , there is only one Year and Month selection for the user

Some of my report is base on the SDate and some of the report is base on the EDate

So i need to use to set analysis to override the date selection .

count({<YearSDate=,MonthSDate=,YearEDate={$(=vYear)},MonthEDate={$(=vMonth)}>}recCount)

I am now using a variable to store the selection , it can make it work when both Year and Month is selected .

However ,if no Year or Month is selection , all record are filtered out. That the problem ..

Anyone can help ?

Set Analysis to make the date selection base on anther Date Field

jonathandienst — Fri, 07 Oct 2011 05:48:54 GMT

I suggest that you make vYear and vMonth based on the maximum date, rather than the selected date. They will then contain the most recent date if nothing is selected, or the selected date if one date is selected, or the most recent selected date if multiple days are selected.

Regards

Jonathan

Re: Set Analysis to make the date selection base on anther Date Field

kaushiknsolanki — Fri, 07 Oct 2011 06:43:13 GMT

Hi,

Have a look at the attached document.

Hope this will help you.

Regards,

Kaushik Solanki

Re: Set Analysis to make the date selection base on anther Date Field

Fri, 07 Oct 2011 07:37:02 GMT

Can i have more detail on the function p() please

sum({<End_Date = p(Date)>}Value)

Re: Set Analysis to make the date selection base on anther Date Field

kaushiknsolanki — Fri, 07 Oct 2011 07:47:08 GMT

Hi,

Function p() is used when you need to have set expression on set expression.

Here in our example p() function includes all the dates from the DataIsland table.

Let me explain you the expession working.

In the expression written we are saying that give me the sum of values where the End_Date is ( include all the Date) Here the date is coming from DataIsland table. So when you select the month shown in example the Dates withh get filter.

Consider you selected Jan. So your Date Field will contains the date from 1st Jan 2011to 31 Jan 2011

So now you will get the sum of values for the end_Date where month is Jan.

Hope this is clear to you.

Regards,

Kaushik Solanki

Re: Set Analysis to make the date selection base on anther Date Field

Mon, 10 Oct 2011 02:49:05 GMT

One more question ...

My situation is, there are 20 reports for my dashboard

17 of it is using EDate and only 3 reports are looking at the SDate.

If i using the DataIsland for the selection, every report i will need to add the set analysis

So i trying to use the DataIsland for that 3 reports only . The dashboard keep using the EDate for selection so no change for that 17 reports.

When i select the Time Dimension , i add action to select the same value on the dataIsland .

But i face the problem of mult-selection . When i select 2 Year , the action can't select perform the same result

Re: Set Analysis to make the date selection base on anther Date Field

kaushiknsolanki — Mon, 10 Oct 2011 04:09:39 GMT

Hi,

Will you please tell me in what way you are trying to implement it., So that i can suggest you any solution for that.

Regards,

Kaushik Solanki

Re: Set Analysis to make the date selection base on anther Date Field

Mon, 10 Oct 2011 08:14:57 GMT

Attached the example file:

When multi-selection , there would be the problem