Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
alexbg1997
New Contributor III

Set analysis for Commercial KPI's

I am currently building a commercial KPI dashboard.

What I want to do is set a number of charts that only utilise restriced selections from one column called 'DIVISION'

DIVISION ranges from 1-22 so I am trying to get the same chart, but each one to only choose from a set number of divisions.

Example:

DIV                              CHART 1                        CHART 2

1                                    DIV 1 & 5                         DIV 2 Only

2

3

4

5

6

The expression can be changed as this isn't the issue what is being calculated, it is the data that is being considered in all charts currently that need restricting.

Thanks

Tags (1)
1 Solution

Accepted Solutions
trdandamudi
Honored Contributor II

Re: Set analysis for Commercial KPI's

May be as below: (I am using version 12)

3 Replies
trdandamudi
Honored Contributor II

Re: Set analysis for Commercial KPI's

May be as below: (I am using version 12)

alexbg1997
New Contributor III

Re: Set analysis for Commercial KPI's

This seems it will work with some small amendments,

Thanks Thirimala

trdandamudi
Honored Contributor II

Re: Set analysis for Commercial KPI's

You are welcome...