topic text in chart in QlikView

text in chart

Anonymous — Thu, 13 Feb 2014 14:53:48 GMT

Hi Guys,

I have a chart in which two expression is there(grouped expression) i want to put unit of exp in the chart. but in my chart one expression has count as unit and other expression has Date as unit. How should i do that

Re: text in chart

andrefpc — Thu, 13 Feb 2014 14:57:17 GMT

Hi Rajashmita! You want the value that appears in the chart to be the sum of the 2 expressions you have?

Re: text in chart

simondachstr — Thu, 13 Feb 2014 14:59:06 GMT

Have you had a look at the number formatting tab in the chart properties? That should work..

Re: text in chart

datanibbler — Thu, 13 Feb 2014 14:59:39 GMT

Hi Rajashmita,

so you have two different dimensions or two expressions?

=> The latter (expressions) you could do by putting one scale on the left, one on the right ("axis" tab)

=> The former can only be done if they are mutually exclusive - you could conditionalize them, but then of course you could only show one of your expressions.

HTH

Best regards,

DataNibbler

Re: text in chart

Anonymous — Fri, 14 Feb 2014 06:18:58 GMT

i have two expression..both has different units. one displays Max(Date) and other display count(Id) , which are grouped. If i select Max(Date) Date should be displayed in chart text and when i select Count(Id) it should display count as unit in chart text. I am using If(GetcurrentSelection(Max(Date)),'N','D') but it is taking only else values that is D....

Re: text in chart

jagan — Fri, 14 Feb 2014 07:29:01 GMT

Hi,

There is no option to get which expression is currently used in Expression group, so the workaround for this is create two charts and provide buttons to toggle or use container and give two charts.

In Expression, Label give your expression instead of some name and it will display in the chart and enable Show Title in Chart option in General tab.

Regards,

Jagan.

Re: text in chart

andrefpc — Fri, 14 Feb 2014 09:10:59 GMT

You can use ad hoc dimension....

MetricsOptions:

LOAD * INLINE [metricsNo, metrics

1, Date,

2, Count,

];

MetricPickOne:

LOAD DISTINCT

metrics as _metricPickOne

RESIDENT MetricsOptions;

Then create a listbox with _metricsPickOne

On your chart, make your expressions conditional, one for the Date and one for the Count, like this:

=SubStringCount(Concat(_metricPickOne, '|'), 'Date')

and the same for the count, that way, when you select date on your list box, the date expression will appear in the chart. Is this what you are looking for?