Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to add multiple measures ( KPI's) in a list box for a single chart

Hi I have a bar chart and I need to provide user an option to select the measures or KPI's in  a listbox so that whatever user selects , gets reflected in the chart. e.g. I have these 3 KPI's ( Sales , Profit , Order Count etc. )  and they need to be plotted against geography dimension. But they have to be one at a time, meaning whatever user selects from the list box that should be shown in the chart.

How is this possible in qlikview ?

Appreciate your help.

Thanks

Ajay

6 Replies

Re: How to add multiple measures ( KPI's) in a list box for a single chart

This blog post Customizable Straight Table explains how to do this as in create "a customizable straight table or ad-hoc report where the user can select the dimensions and measures that should appear in the chart"

hirishv7
Honored Contributor

Re: How to add multiple measures ( KPI's) in a list box for a single chart

Hi,

Can You provide a sample app! or Data.

-Hirish

Re: How to add multiple measures ( KPI's) in a list box for a single chart

Have you looked at the blog post Customizable Straight Table I suggested ?

It contains links to a sample app, data and step by step instructions.

Re: How to add multiple measures ( KPI's) in a list box for a single chart

If you don't need a complete customizable chart you could use expression-groups - the switch between the expressions won't be happen per listbox else per small circle-button within the chart (in header by table-charts and dragable by other chart-types).

- Marcus

hirishv7
Honored Contributor

Re: How to add multiple measures ( KPI's) in a list box for a single chart

Hi,

Check this as per the Bill suggestion,

Customizable straight table,

By creating Dimensions and Expressions like this,

Data:

LOAD Customer,

     [Sales Order ID],

     ShipDate as Date,

     Product,

     Sales,

     Quantity

FROM

[Sales Orders.xls]

(biff, embedded labels, table is [Sales Orders$]);

Dimensions:

LOAD * INLINE [Dimensions

  Call Customer

  Call Date

  Call Sales Order ID

  Call Product

];

MetricsORMeasures:

LOAD * INLINE [MetricsORMeasuresNO'S,MetricsORMeasures

1,Call Sales

2,Call Quantity

];


Front End:

Customizable Straight Table-201180.PNG

Using the Selection of dimensions and expression through list box , the straight table will display the Results.

Hope this helps,

PFA,

Hirish

Not applicable

Re: How to add multiple measures ( KPI's) in a list box for a single chart

Thanks Bill,

I will go through this blog and try to implement it.

Thanks

Ajay

Community Browser