topic Re: help in set analysis in QlikView

help in set analysis

ali_hijazi — Mon, 08 Dec 2014 12:47:54 GMT

Hello

Got a chart by MonthYear

I want to count the distinct TPKs having the fact that the waste Ratio is > defined threshold

check attached file and help please as when I select a specified month and year the number differs from when no selection is made on the month and year

knowing that the waste ratio (refer to vWasteRatioRelativeThreshold gives correct results

Re: help in set analysis

Anonymous — Mon, 08 Dec 2014 13:16:19 GMT

Hope i have observed the calculations properly.

I notice that the difference comes because of the below condition.

CALENDAR_DATE={">= $(vFromDate) <=$(vToDate)"}

here the vToDate value is getting changed everytime you select a month the last date of the month is assigned to this variable.

but the vFromDate is still kept to be at the beginning of the year.

and hence the data is filtered only for that particular period. and hence the calculation also differs.

Hope this helps.

Aadil

Re: help in set analysis

ali_hijazi — Mon, 08 Dec 2014 13:20:33 GMT

yes and when I select a month Year it will fall between vFromDate and vToDate

there shouldn't be any difference

Re: help in set analysis

ali_hijazi — Mon, 08 Dec 2014 13:36:40 GMT

cause what I want is that when user select a specific month this means the chart will show result from starting day of the year till selected month

Re: help in set analysis

Anonymous — Mon, 08 Dec 2014 14:01:06 GMT

Just a doubt, that without making any selections. whatever values the bar chart shows. is that correct. Because when i do the same thing with IF conditions i am getting different figured. So just wanted to know if you have verified the numbers and are they correct.

Re: help in set analysis

rajeshvaswani77 — Mon, 08 Dec 2014 14:18:13 GMT

Dear Ali,

If I eliminate from set analysis

TPK={"=($vWasteRatioRelativeThreshold)) > $(vPercentThreshold)"}

The values show fine in the bar chart

This means this condition here is having the issue.

Also I notice that the variable vWasteRatioRelativeThreshold has a formula that uses TestID

You will have to check this part.

Thanks,

Rajesh Vaswani

Re: help in set analysis

stigchel — Mon, 08 Dec 2014 14:27:59 GMT

The value for vWasteRatioRelativeThreshold changes when you select a month. If you want this to be a constant for e.g. the year, change the set analysis for the calendar_date for this variable.