topic 8020 chart Display by sales ok but eXP not okay. in QlikView

8020 chart Display by sales ok but eXP not okay.

paulyeo11 — Fri, 01 Apr 2016 16:04:53 GMT

Hi All

I have Chart 1 work fine . When i select measure = sales. The expression as below :-

if(Num(Rank(sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}sales/$(Columndim89))

sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} TOTAL <$(ColumnDim_p)

> sales/$(Columndim89))))<=15,sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}

sales/$(Columndim89))

sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}

TOTAL <$(ColumnDim_p)

> sales/$(Columndim89))),

When i select meansure = eXP ( By click on step 2 ) , My expression now working.

The differeent between sales and eXP are :-

For sales = sales , But for eXP = Sum({<eXP={"eXP"}>}Amount)

My question is how to replace sales to eXP to above expression ?

Paul

Re: 8020 chart Display by sales ok but eXP not okay.

paulyeo11 — Fri, 01 Apr 2016 16:06:19 GMT

My QV Doc

Re: 8020 chart Display by sales ok but eXP not okay.

sunny_talwar — Fri, 01 Apr 2016 22:50:57 GMT

Man, your questions are such a brain teasers .

I think I am not going to help you before Monday because I need to rest my mind

Re: 8020 chart Display by sales ok but eXP not okay.

paulyeo11 — Sat, 02 Apr 2016 00:03:38 GMT

Hi sunny

yes that expression from settu , too complicated. ccan plot the chart very fast.

https://community.qlik.com/thread/211307

may be on monday you can help me use the old expression not so complicated to change to eXP as below :-

i have expresion work fine below for sales field shown in chart 1:-

sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89))

sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} TOTAL <$(ColumnDim_p) > $(ColumnDim51)/$(Columndim89))

I have try as below but the chart not working :-

sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}eXP={eXP}>}Amount*1/$(Columndim89))

sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} TOTAL <$(ColumnDim_p)> eXP={eXP}>}Amount*1/$(Columndim89))

I am more then happy if the above work.

Paul