Graph Issue

[raajgote]

I am facing issue while plotting graph with 2 dimensions(country,phase) and 2 expressions(average age and average age of selected country). It works pretty fine with one expression but when i add second expression, country will be automatically removed from the graph and second expression takes it place.

I have selected Chart type as Combo and wanted to plot a graph across average age across phase and country with one line from second expression which contains average age of selected countries.

Your Help i s highly appreciated!!

Thanks,

Raaj...

[#2]

Can you attach a sample app?

[ramkrishna86]

I think you have made some mistake while writing your expression, please recheck or attach a sample so that i can correct and help you.

[raajgote]

please let me know how to attach the file..

[#5]

When you click on reply, on top right corner, there will be one option "Use Advanced Editor", click on that and it will open a new window.

In this new window, at right bottom there is an option to attach file.

Here you can attach your file.

[raajgote]

Thanks Shyamal!!!

PFA the same.

[#7]

You can refer to this:

http://community.qlik.com/thread/85342

looks like similar issue, might be of help.

[raajgote]

Its having only one dimension. Average is not calculated anywhere...

Thanks for the efforts but our requirement is something different.

[#9]

There are 2 dimensions which are later combined into one to resolve the issue.

You can also try combining your dimesions into one. Something like:

  =PhaseName & CountryName

This way when you will add the second expression, CountryName won't get lost. Then you can sort the expression based on the expression (Avg).

Edit: PFA, since I am not sure what second expression you want, I have just added 1.