Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Not applicable

8020 chart Display by sales ok but eXP not okay.

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

3 Replies
paulyeo11
Not applicable

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

My QV Doc

sunny_talwar
Not applicable

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

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

paulyeo11
Not applicable

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

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