HOw to get line chart based on current selection ??

[nikhilgarg]

HEy,

How can i show a line chart based on the selection i select. I have a security field. Whatever security  select it gives corresponding graph. How can i do it ?? How to write the expression ??

Thanks

[DavidFoster1]

You need to give us more information about the data.

[#3]

Hi Nikhil

Do you mean conditionally show whether a chart appears based on a selection? The option you are looking for is "conditional show". It is in the layout tab of the chart properies, under "show".

Select the option button and write a logic statement that evaluates to true when you want the chart to show.

eg =count(distinct FieldName) = 1

will show the chart if and only if there is one possible value in fieldname.

Erica

[nikhilgarg]

Hey,

I ahve one field: Security and its Price as second Field.

Now i want to create a line chart to show the price of a particular security that i select from field box.

I mean if i select security as abc den a line chart showing varying price of abc from year 2013 - 2014 should appear. How can i do so??

[nikhilgarg]

Hey,

I ahve one field: Security and its Price as second Field.

Now i want to create a line chart to show the price of a particular security that i select from field box.

I mean if i select security as abc den a line chart showing varying price of abc from year 2013 - 2014 should appear. How can i do so??

[DavidFoster1]

That is basic qlikview functionality.

Create a line chart with year as the dimension and sum(Price) as the expression.

Create a list box of security

As you make selections in Security the lilne chart will change to match

[#7]

Dear Nikhil,

But you don't have year wise price of a particular security.

So what should be display in year wise price?

Thanks & Regards

Prince Anand

[nikhilgarg]

HEy,

I have price of security month adn year wise , from jan2013 - dec2014

[#9]

Dear Nikhil,

Do you have any sepereate field of Year-Month or concatenated with security field like abcJan-2013?

Thanks & Regards

Prince Anand

[nikhilgarg]

Yeah i have separate field of year month