Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
My QV Doc
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
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