Restrict Field Value in line chart

[Anonymous]

Hello everyone

I come to know how to restrict field value in line chart.

I have 5 values in KPI but want to show only 4 values in line chart.

how restrict it?

Thanks.

[kakani87]

=if(GetSelectedCount(Region) > 'Central',Region, IF(NOT MATCH(Region, 'Central'), Region))

[Anonymous]

not working

[kakani87]

prachi DHOK wrote:

not working

What about?

[MK_QSL]

=IF(Region <> 'Central',Region)

use above calculated dimension

and don't forget to tick suppress null values for this calculated dimension

[Anonymous]

i already used this.

its same as below expression

=if(GetSelectedCount(Region) > 'Central',Region, IF(NOT MATCH(Region, 'Central'), Region))

[MK_QSL]

So what is your requirement?

[Anonymous]

i have KPI field which is contain 5 value but i want to show only 4 kpi's in line chart(without hard coded).

[shiveshsingh]

in your shared app, i can see only 4 values.But you are saying it has 5..

[Nagaraju_KCS]

Use script level

IF(Region <> 'Central',Region) as Region1

Then use Region1 as  Dimension

[Peter_Cammaert]

If you don't want hardcoded dimension exclusion/inclusion values, then how do you want to tell QlikView which value must be excluded? Do you want to select the value to exclude from a listbox? Or do you want to see just a maximum of 4 values, whatever their order? Or maybe just those 4 with the highest aggregation result?