topic Re: HOw to get line chart based on current selection ?? in QlikView

HOw to get line chart based on current selection ??

nikhilgarg — Wed, 08 Oct 2014 10:02:30 GMT

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

Re: HOw to get line chart based on current selection ??

DavidFoster1 — Wed, 08 Oct 2014 10:09:52 GMT

You need to give us more information about the data.

Re: HOw to get line chart based on current selection ??

Wed, 08 Oct 2014 10:15:33 GMT

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

Re: HOw to get line chart based on current selection ??

nikhilgarg — Wed, 08 Oct 2014 10:28:00 GMT

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??

Re: HOw to get line chart based on current selection ??

nikhilgarg — Wed, 08 Oct 2014 10:28:06 GMT

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??

Re: HOw to get line chart based on current selection ??

DavidFoster1 — Wed, 08 Oct 2014 10:31:43 GMT

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

Re: HOw to get line chart based on current selection ??

Wed, 08 Oct 2014 10:44:14 GMT

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

Re: HOw to get line chart based on current selection ??

nikhilgarg — Wed, 08 Oct 2014 10:49:19 GMT

HEy,

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

Re: HOw to get line chart based on current selection ??

Wed, 08 Oct 2014 10:53:56 GMT

Dear Nikhil,

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

Thanks & Regards

Prince Anand

Re: HOw to get line chart based on current selection ??

nikhilgarg — Wed, 08 Oct 2014 11:03:59 GMT

Yeah i have separate field of year month

Re: HOw to get line chart based on current selection ??

Wed, 08 Oct 2014 11:19:30 GMT

Dear Nikhil,

Simple take year as dimension and use sum(Price) as expression and use condition expression for it and in condition use the expression like:-

getselectedcount(security)=1.

Then price will only show if we have one selected value in field Security and only for selected security.

Thanks & Regards

Prince Anand