Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Show chart in the table

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?

1 Solution

Accepted Solutions
johnpaul
Contributor

Re: Show chart in the table

see attached.

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

7 Replies
MVP
MVP

Re: Show chart in the table

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.

Not applicable

Re: Show chart in the table

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?

MVP
MVP

Re: Show chart in the table

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?

Not applicable

Re: Show chart in the table

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.

raghavsurya
Valued Contributor

Re: Show chart in the table

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

Not applicable

Re: Show chart in the table

Hi,

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

johnpaul
Contributor

Re: Show chart in the table

see attached.

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

Community Browser