topic display data which does not match the filters selected in QlikView

display data which does not match the filters selected

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

Hi all,

I want to achieve the following scenario in my report,

I have a slider with values from 1 to 100 which is the product score, and when the user makes a selection of 10 to 20 all those products which donot satisfy the condition 10 to 20 should be displayed in the table below.

How can i achieve this ?

Kindly share your thoughts on this.

Thanks

Re: display data which does not match the filters selected

sudhirpkuwar — Mon, 02 Apr 2018 07:49:27 GMT

Hi Chandana,

In the Set Analysis of the table expression use the {1-$} set identifier

For Eg. sum( {1-$} Sales )

This will show data which is not related to the selection.

Hope this will for you.

Thanks & Regards,

Sudhir

Re: display data which does not match the filters selected

suren946 — Mon, 02 Apr 2018 09:38:38 GMT

Try below expression

if(not match(only({1} Product), $(=concat(distinct Product,','))),'NA')

Re: display data which does not match the filters selected

Anonymous — Mon, 02 Apr 2018 13:16:58 GMT

Hi Surendra ,

Are you using the above given expression in table ?

And have u used any variable ?

I am new to qlikview, please don't mind to explain this expression in detail.

Thanks

Re: display data which does not match the filters selected

suren946 — Mon, 02 Apr 2018 13:38:11 GMT

Hi,

Share some sample data how you want to present so that the community can try to help you

Re: display data which does not match the filters selected

Anonymous — Mon, 02 Apr 2018 14:56:20 GMT

Hi ,

Below given is the scenario:

show only characteristic(s) that does not meet, in case

1. Current Rating - Requirement Rating < 0

2. Current Rating - Recommended Rating < 0

below given is the layout available

The slider , country and region are the filters..

the below table should meet this ( show only characteristic(s) that does not meet, in case

1. Current Rating - Requirement Rating < 0

2. Current Rating - Recommended Rating < 0 ) condition.

Kindly suggest on how to achieve this.

Attached is the sample data

Id	Type	Characteristics Name	Current Scaling	Recommended Scaling	Requirement Scaling	ProductScore
500000710	Comfort / Productivity	Dexterity	5	20	20	20.5
500000710	Comfort / Productivity	Dexterity	10	5	5	25.5
500000710	Comfort / Productivity	Dexterity	20	6	6	30.5
500000710	Comfort / Productivity	Dexterity	15	7	7	35.5
500000710	Comfort / Productivity	Dexterity	16	15	15	40.5
500000870	Comfort / Productivity	Dexterity	18	12	12	45.5
500000870	Comfort / Productivity	Dexterity	19	16	16	50.5
500000870	Comfort / Productivity	Dexterity	7	11	11	55.5
500000870	Comfort / Productivity	Dexterity	5	15	15	60.5
500000870	Comfort / Productivity	Dexterity	5	5	5	65.5