Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
treborscottnam
New Contributor II

Can you show the detail of what was filtered out?

Hello,

Is it possible to show the detail for those who were filtered out of a group? This is for a Penetration report. The client wants to see, in a market, who is not receiving the product. So the product needs to be selected shown that they are not receiving it. However, it needs to be shown with those who did receive it.

Example Data:   

AreaCityMarble
EastAtlantaRed
EastBostonRed
EastHartfordRed
EastJacksonvilleBlue
EastNew YorkBlue
EastProvidenceRed
WestLos AngelesRed
WestLos AngelesBlue
WestPhoenixRed
WestPhoenixBlue
WestSacramentoRed
WestSacramento

Blue

For example, I first filter the data to see only the East - Atlanta, Boston, Hartford, Jacksonville, New York and Providence.

Then I filter further to just see those who have Red marbles. That leaves me with Atlanta, Boston, Hartford and Providence. Even though it is just the Red marbles, I want to see all the East Area cities to get those cities. Then I can do a penetration percent (6 / 4 = 66.7%). The client also wants to see these individuals to export to Excel.

The only way I think I can express this, is that it is like filtering down to a point, and then freezing the filter, then filter further but not losing that group. Those who are "extra filtered" remain visible, but highlighted or something like that.

Does that make any sense?


Thank you for the help.


p.s.  What IT's solution has been is to get all the possible products and then add them to each city and add a flag if they actually got the marble or if it is a faked row. The problem is the data has become enormous (Cartesian join!) and they can only load about a year or two worth of data.  That does not seem like a good idea to me.

1 Solution

Accepted Solutions

Re: Can you show the detail of what was filtered out?

Hi,

glad it helped.

I used this Text Color function for all dimensions:

QlikCommunity_Thread_240669_Pic5.JPG

Note that this only formats the text while ignoring the Marble field selections is done using the set expression {$<Marble>}.

Please take some time and close this thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks

regards

Marco

6 Replies
rupamjyotidas
Valued Contributor

Re: Can you show the detail of what was filtered out?

This can help you

Show excluded values in straight table

Flagging the fields would help a lot.

Re: Can you show the detail of what was filtered out?

Hi,

maybe one solution could be:

QlikCommunity_Thread_240669_Pic1.JPG

QlikCommunity_Thread_240669_Pic2.JPG

QlikCommunity_Thread_240669_Pic3.JPG

QlikCommunity_Thread_240669_Pic4.JPG

hope this helps

regards

Marco

treborscottnam
New Contributor II

Re: Can you show the detail of what was filtered out?

Hi Marco,

Thank you so much for this! It appears to be the perfect solution I was looking for. 

Would you mind giving me more information about how you got the non-selected rows to grey-out instead of being filtered out?  I was looking at the QVW you provided, but I cannot seem to figure it out.

I really appreciate you taking the time to provide this answer to me. It is such a great help.

treborscottnam
New Contributor II

Re: Can you show the detail of what was filtered out?

Rupam,

I appreciate you sending the link, it is very helpful.

Re: Can you show the detail of what was filtered out?

Hi,

glad it helped.

I used this Text Color function for all dimensions:

QlikCommunity_Thread_240669_Pic5.JPG

Note that this only formats the text while ignoring the Marble field selections is done using the set expression {$<Marble>}.

Please take some time and close this thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks

regards

Marco

treborscottnam
New Contributor II

Re: Can you show the detail of what was filtered out?

Marco,

This is a huge help for me. I really appreciate you taking the time to respond with such great information. You saved me a great deal of time (and aggravation).