topic Adding Spark-line to a pivot table column in QlikView

Adding Spark-line to a pivot table column

Wed, 06 Nov 2013 23:17:32 GMT

Does anyone have a document or explanation with an example of a spark-line being added to a column within a pivot table. If someone id it would really make my day.

Be well,

QlikViewGirl

Re: Adding Spark-line to a pivot table column

cn_sa_dev — Thu, 07 Nov 2013 07:43:40 GMT

Hi Cynthia,

As far as I know you can't add a sparkline to a pivot table, only a straight table.

To create a sparkline on a straight table:

Firstly create an expression
Then under display options choose minichart
Select a time dimension from the drop down
Customise your sparkline

Regards,

Chris

Re: Adding Spark-line to a pivot table column

israrkhan — Thu, 07 Nov 2013 08:45:26 GMT

Hi Cynthia,

Sparkle line is the display option for mini chart, and mini chart is available for Straight Table,

in pivot table mini chart is not available, but you can add other like circular gauge, linear gauge etc

if you want sparkle line the convert it to straight table, as shown in above post...

Khan