topic Re: RE: sum of years in QlikView

RE: sum of years

Chanty4u — Mon, 01 Aug 2016 05:20:24 GMT

Hi all,

I have one year filed

2014-2015

2016-2017 lik dat

i hve below exprsin used in gauge chart

Sum({<Year={$(=Max(Year))},TR_Date={">=$(vStartDate)<=$(vMonthEndDate)"},Quarter=,HalfYearFin=,Month=,Day=>}Cc_COUNT)

its working fine wen i select one year means[2014-2015] but wen i select two years both [2014-2015 and 2016-2017]

the result is not cmg with sum . only it is shwng max year values . what is the issue ? anyone trace out this?

Re: RE: sum of years

kaushiknsolanki — Mon, 01 Aug 2016 06:09:47 GMT

Hi,

This is because you have written it in set analysis to get max year.

See the script part "Year={$(=Max(Year))}"

So what ever year selection you will do, it will pick up the max out of it and show the result for that year.

If you want sum for both years, then remove that section from set analysis.

Regards,

Kaushik Solanki

Re: RE: sum of years

Mon, 01 Aug 2016 06:33:16 GMT

Hi sureshqv,

Kaushik is correct you need to remove max(year) condition in set expression and try.

Re: RE: sum of years

Chanty4u — Mon, 01 Aug 2016 06:37:35 GMT

thnks kaushik.

i tried below still doesnt work anymore

1) Sum({<TR_Date={">=$(vStartDate)<=$(vMonthEndDate)"},Quarter=,HalfYearFin=,Month=,Day=>}Cc_COUNT)

2) Sum({<Year=,TR_Date={">=$(vStartDate)<=$(vMonthEndDate)"},Quarter=,HalfYearFin=,Month=,Day=>}Cc_COUNT)

Re: RE: sum of years

Anil_Babu_Samineni — Mon, 01 Aug 2016 06:38:19 GMT

As i know double quotes is not the problem , Can you please share your Sample App

Re: RE: sum of years

kaushiknsolanki — Mon, 01 Aug 2016 06:39:00 GMT

Hi,

Please share a sample data along with the selection which you are doing and expected output.

Regards,

Kaushik Solanki

Re: RE: sum of years

Chanty4u — Mon, 01 Aug 2016 06:41:33 GMT

Its nt psble. as its on server

Re: RE: sum of years

kaushiknsolanki — Mon, 01 Aug 2016 06:43:31 GMT

Probably you can just give us the sample data which can replicate your problem.

Data can be anything, which shows the problem you are facing.

Regards,

Kaushik Solanki

Re: RE: sum of years

Anil_Babu_Samineni — Mon, 01 Aug 2016 06:43:36 GMT

Sum({<Year=, Month=, Quarter=, Day=, TR_Date={">=$(=Num(MonthStart(TR_Date)))<=$(=Max(vMonthEndDate))"}>} Sales)

Re: RE: sum of years

Chanty4u — Mon, 01 Aug 2016 06:45:52 GMT

let me try .Thanks

Re: RE: sum of years

Chanty4u — Mon, 01 Aug 2016 08:49:53 GMT

not wrking anil.

below are the variables v r usng

vStartDate

=If (GetSelectedCount(Month)=0 And GetSelectedCount(Quarter)=0,MonthStart(Date(Max(Date))),Date(Min(Date)))

vMonthEndDate

=MonthEnd(max(Date))