topic Problem with $ expression in Combo Chart in QlikView

Problem with $ expression in Combo Chart

StevePaulich — Thu, 06 Dec 2018 19:31:47 GMT

I'm having issue with $ variable in Combo Bar Chart aggregation.

1st, I need to use Combo Chart.

X axis is FISCAL_YEAR_APR,

Left Y is SUM(APR_AMOUNT),

Right Y is SUM(COST_FINAL).

I have defined a variable (vAPR) as APR.

My specific problem is with the Stacked Bars I need for SUM(APR_AMOUNT).

The expression I'm using is: =sum({< [APR]={'=$(vAPR)'} >} [APR_AMOUNT] ).

Other versions of the expression have been tested but I've not figured it out. I've attached a .qvd with my progress. In this .qvd there are two years properly displaying because I specifically denoted the APR's in the expression using (example) =sum({< [APR]={'19-HLP-04'} >} [APR_AMOUNT] ). How do I get my variable to generate the multiple stacks in the bar chart? There's got to be a way!

Thank you in advance.

SteveP

Re: Problem with $ expression in Combo Chart

hopkinsc — Thu, 06 Dec 2018 20:29:51 GMT

Hi,

What is the APR field and how is it used to make the calculation you require?

If i select 2010, there are 8 possible APR values, can you break down the calculation needed ?

Re: Problem with $ expression in Combo Chart

StevePaulich — Thu, 06 Dec 2018 20:34:12 GMT

APR is our term for "project number". What I need to see is the SUM of APR_AMOUNT for each APR in a stacked bar for the X axis "FISCAL_YEAR_APR". So, in 2010, I'd need to see 8 different colored stacked sections totaling $937,837. See the columns for 2018 and 2019 for examples.

Re: Problem with $ expression in Combo Chart

StevePaulich — Thu, 06 Dec 2018 20:41:14 GMT

I stopped entering expressions for each [APR] after completing 2018 & 2019. It was killing to do that because I know there's got to be a better way of yielding the desired result.

Re: Problem with $ expression in Combo Chart

hopkinsc — Thu, 06 Dec 2018 21:17:45 GMT

Hi, i have the attached working with a single expression, but as soon as you add the 2nd it breaks...

Re: Problem with $ expression in Combo Chart

StevePaulich — Thu, 06 Dec 2018 21:22:37 GMT

Thank you. I think I'm going to redesign the dataset and see where that takes me.