Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
rehanlearns
New Contributor

How to exclude data from showing on entire dashboard

is it possible to complete remove data of a field from entire dashboard.

for example I have

the data loaded below .

I would like to completely remove data for Fruit Segment - Apple from entire chart . Since the graph does not have any figures. I am counting the total number of fruits in fruit segment and name .

so it is throwing the number off . Even if i exclude apple in script editor by excluding it . when i count(fruit segment) it still shows up .

3 Replies
Highlighted

Re: How to exclude data from showing on entire dashboard

This will throw out entire object for Apple.

Count({<[Fruit Segment] -= {'Apple'}>} Fruit)

Even if i exclude apple in script editor by excluding it . when i count(fruit segment) it still shows up .

Impossible, May be you have case insensitive data. Can you try with UPPER() and do exclude instead of simple ..

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Partner
Partner

Re: How to exclude data from showing on entire dashboard

Hi,

You  can try this one into your expression:

If(not Wildmatch(fruit,'Apple'),Count(Fruit))

Regards,

Mithilesh

Highlighted

Re: How to exclude data from showing on entire dashboard

You need exclude the data from all the table ..i.e. if your eliminating apple data then you need eliminate in fact and Dimension tables also so that it won't affect the count