topic Re: Sparkline in a Pivot Chart in QlikView

Sparkline in a Pivot Chart

Fri, 10 Feb 2017 11:40:49 GMT

Hi all,

A quick question, do you know if we can create a sparkline in a pivot table, similar to the below.

We currently have 4 Dimensions in the pivot, with the date in columns. (The date is a Dimension)

The Expression = the sum of activity for each date in the format Month Year.

I know that this is possible using the Chart Properties - Chart Type - Straight table, because we have the MiniChart Representation under Expressions. However with the straight table we can not customise properly or group like Product Name.

Thank you so much for reading

Re: Sparkline in a Pivot Chart

vinieme12 — Fri, 10 Feb 2017 11:48:48 GMT

can you post some sample data

Re: Sparkline in a Pivot Chart

Anil_Babu_Samineni — Fri, 10 Feb 2017 12:06:13 GMT

I don't think so whether we can achieve this in Pivot Table. But, We can do in Straight Table. What was the problem to do in Straight Table

From below, If we want to remove Square rackets that we can do

Re: Sparkline in a Pivot Chart

rahulpawarb — Fri, 10 Feb 2017 12:07:11 GMT

Hello Mary,

Trust that you are doing well!

As per my knowledge, Mini Charts option is only available in the Expressions page of a straight table's Properties dialog (refer - Mini chart settings ‒ QlikView).

However, you can make use Linear Gauge chart (if it suits your requirement).

Regards!

Rahul

Re: Sparkline in a Pivot Chart

sdmech81 — Fri, 10 Feb 2017 12:11:13 GMT

Hi yes u can.

Click on minichart,,go to mini chart properties select dimension.

Attach file if u facing problem..:)

Sachin

Re: Sparkline in a Pivot Chart

Anil_Babu_Samineni — Fri, 10 Feb 2017 12:20:51 GMT

I don't think Pivot can have this Settings

Re: Sparkline in a Pivot Chart

Fri, 10 Feb 2017 12:26:53 GMT

Thanks for the prompt reply Vineeth .

Below is some sample data.

Re: Sparkline in a Pivot Chart

Fri, 10 Feb 2017 12:30:54 GMT

Thanks Anil.

We want to have something similar to the below:

I dont think it is possible to achieve this using a straight table.

Re: Sparkline in a Pivot Chart

Fri, 10 Feb 2017 12:33:47 GMT

Thanks for the reply Sachin.

I have attached the sample file below.

I can not find the "Mini chart" properties under dimensions

Re: Sparkline in a Pivot Chart

Anil_Babu_Samineni — Fri, 10 Feb 2017 12:42:46 GMT

Use Generic Load for cross like months and then create Straight Table

For more information on Generic follow this Use cases for Generic Load | Qlikview Cookbook

Re: Sparkline in a Pivot Chart

sdmech81 — Fri, 10 Feb 2017 12:48:39 GMT

Hi,

Sorry this option of mini chart is not there for Pivite table and only available in Straight Table.

Excuse for that:)

Thanks