topic Re: Show chart in the table in QlikView

Show chart in the table

Fri, 22 Jun 2012 13:42:04 GMT

Goal:

Show chart in the column of the table for each year. I want to show chart in month for for all years.

Problem:

I don't know how to do it?

Re: Show chart in the table

swuehl — Fri, 22 Jun 2012 13:57:03 GMT

I assume you have data for single dates, then you can use QV date and time functions to create e.g. Months:

LOAD

Date,

Value,

Year,

Month(Date) as Month,

MonthName(Date) as Month2

FROM Table;

And then use the Month or Month2 field as dimension (in addition to Year or stand-alone) in your table chart.

Re: Show chart in the table

Fri, 22 Jun 2012 17:46:08 GMT

Hi swuehl,

If I understand from your side, your solution can visualize a chart type for instance bar, line funnel chart based on data of month?

Re: Show chart in the table

swuehl — Sat, 23 Jun 2012 12:21:53 GMT

My solution creates additional fields in your data model, namely Month and Month2. You can then use these fields as dimension in a chart to group your data by.

These charts can be of any type that takes a dimension, bar chart, line chart etc.

Not sure if I understand your issue properly, could you post some sample lines of data and your expected outcome?

Re: Show chart in the table

Mon, 25 Jun 2012 20:18:49 GMT

I have attached some files in this message.

In the table, inside of the qlikview file, I need to add a bar or line chart (display in month) for each row based on year.

Look at the picture..png and its red mark. My request is to get that selected red one in my qlikview application.

Re: Show chart in the table

raghavsurya — Tue, 26 Jun 2012 06:49:20 GMT

Hi,

Add a new expression in your straight table and in Expressions tab > Display Options>selection representation as "Mini Chart". Click on mini chart properties and you will get the option to select many modes. Here you can select the right dimension and have graph/chart within a straight table chart.

Regards,

Raghav

Re: Show chart in the table

Sun, 15 Jul 2012 21:12:49 GMT

Hi,

I have tried many times and I can't achieve the result.

Re: Show chart in the table

johnpaul — Mon, 16 Jul 2012 04:33:55 GMT

see attached.

The key is that you need to choose the correct type of dimension so that the chart looks right.