topic Add multiple sum expressions to chart data without the dialog box in QlikView

Add multiple sum expressions to chart data without the dialog box

Wed, 15 Feb 2012 19:40:43 GMT

I have over 50 expressions to add to a chart. Is there an alternative to the chart properties expressions tab dialog box?

Add multiple sum expressions to chart data without the dialog box

mdmukramali — Wed, 15 Feb 2012 20:00:10 GMT

dear,

i think their is no other way to chart properties expression tab.

but i don't understand why you want to add 50 expresions to a single chart...

Add multiple sum expressions to chart data without the dialog box

Wed, 15 Feb 2012 20:13:44 GMT

I am new to QV. I am trying to create a bar chart with 50 states and would like to be able to click on the state in a table object and only see that states information based on two values for each year.

Add multiple sum expressions to chart data without the dialog box

mdmukramali — Thu, 16 Feb 2012 05:31:18 GMT

Dear,

Then no need to write 50 expressions ...One expression is enough.

create a chart with two dimensions country,Year and write the expression like =sum(sales) it will show the sales per country.

when you select a country it will show the current selection country chart only...

hope this one will help you.

Thanks,

Mukram.

Re: Add multiple sum expressions to chart data without the dialog box

v_iyyappan — Thu, 16 Feb 2012 06:09:31 GMT

Hi,

I am using Year,Country in dimension and Expression like Sum(Value).Based on Year, Country it display the value. May be helpful for u.I attach a sample QV file.

Regards,

Iyyappan