Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Creator
Partner - Creator

see attached.

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

View solution in original post

7 Replies
swuehl
MVP
MVP

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
Author

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?

swuehl
MVP
MVP

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
Author

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
Partner - Specialist
Partner - Specialist

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
Author

Hi,

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

johnpaul
Partner - Creator
Partner - Creator

see attached.

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