topic Restrict Field Value in line chart in QlikView

Restrict Field Value in line chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Restrict Field Value in line chart

kakani87 — Sat, 24 Mar 2018 06:18:58 GMT

Can you post some sample data

Re: Restrict Field Value in line chart

Anonymous — Sat, 24 Mar 2018 06:26:09 GMT

Please find attached file

Re: Restrict Field Value in line chart

Anonymous — Sat, 24 Mar 2018 06:26:47 GMT

I don't want to show data for Cetral Region.

Re: Restrict Field Value in line chart

kakani87 — Sat, 24 Mar 2018 07:05:31 GMT

Check this

Re: Restrict Field Value in line chart

Anonymous — Sat, 24 Mar 2018 07:34:03 GMT

i am not able to open in personal edition. Plese share screenshot.

Thanks

Re: Restrict Field Value in line chart

kakani87 — Sat, 24 Mar 2018 07:44:14 GMT

In chart add this expression

=Count({<Region={NE,SE,W}>}Investment)

Re: Restrict Field Value in line chart

Anonymous — Sat, 24 Mar 2018 07:53:05 GMT

i dont want to do hardcoded. any other solution is there?

Re: Restrict Field Value in line chart

Anonymous — Sat, 24 Mar 2018 07:58:18 GMT

I want to used in dimension not in expression

Re: Restrict Field Value in line chart

kakani87 — Sat, 24 Mar 2018 08:22:04 GMT

Use this expression in list box instead of selecting a field

=if(match(Region,'NE','SE','W'),Region)

Re: Restrict Field Value in line chart

kakani87 — Sat, 24 Mar 2018 08:40:37 GMT

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

Re: Restrict Field Value in line chart

Anonymous — Sat, 24 Mar 2018 08:51:37 GMT

not working

Re: Restrict Field Value in line chart

kakani87 — Sat, 24 Mar 2018 09:00:48 GMT

prachi DHOK wrote:

not working

What about?

Re: Restrict Field Value in line chart

MK_QSL — Sat, 24 Mar 2018 09:05:02 GMT

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

use above calculated dimension

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

Re: Restrict Field Value in line chart

Anonymous — Sat, 24 Mar 2018 10:51:51 GMT

i already used this.

its same as below expression

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

Re: Restrict Field Value in line chart

MK_QSL — Sat, 24 Mar 2018 10:59:07 GMT

So what is your requirement?

Re: Restrict Field Value in line chart

Anonymous — Mon, 26 Mar 2018 06:57:10 GMT

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

Re: Restrict Field Value in line chart

shiveshsingh — Mon, 26 Mar 2018 07:12:28 GMT

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

Re: Restrict Field Value in line chart

Nagaraju_KCS — Mon, 26 Mar 2018 07:20:32 GMT

Use script level

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

Then use Region1 as Dimension

Re: Restrict Field Value in line chart

Peter_Cammaert — Mon, 26 Mar 2018 07:43:48 GMT

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?