Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Partner
Partner

Show all values where at least 1 value correspondents the selected value whitin a diminsion??

Hello all,

I got a challenging question at leat that is challenging for me. Maybe it is best to just take a look at the Excel if you would be so kind.

Show all values besides selected value whitin a diminsion, where the outcome contains at least the selected value.

1) I would like to select the barcode in a filter

2) When i select 101 i would like to see all productnumbers with barcode 101 BUT ALSO all other barcodes and productnumbers  

Where there is at least one barcode 101 in it


I hope somebody had an idea how to fix this, i am looking forward to your answer. You can sent QS file in the script.


Many thanx Martijn


1 Solution

Accepted Solutions
Partner
Partner

Re: Show all values where at least 1 value correspondents the selected value whitin a diminsion??

Hi Martijn,

The following expression will do the job:

count

(

{<

Productnumber=p({<Barcode=p(Barcode)>}Productnumber),

Barcode

>}

Barcode

)

So what it does it gets the possible values of product numbers for the selected barcode filter and applies to the set analyis you want, and removes the filter you made (in your case the 101) from the total count.

As an example, the result is the followingsample.png

sample.png

5 Replies
Partner
Partner

Re: Show all values where at least 1 value correspondents the selected value whitin a diminsion??

Hi Martijn,

The following expression will do the job:

count

(

{<

Productnumber=p({<Barcode=p(Barcode)>}Productnumber),

Barcode

>}

Barcode

)

So what it does it gets the possible values of product numbers for the selected barcode filter and applies to the set analyis you want, and removes the filter you made (in your case the 101) from the total count.

As an example, the result is the followingsample.png

sample.png

Partner
Partner

Re: Show all values where at least 1 value correspondents the selected value whitin a diminsion??

You are my Hero Filipe, i got it working in my situation.

Interesting to see, how you solved it, i will look to that later, but again, you are my hero and save me lot of time.

Many thanks:-)

Partner
Partner

Re: Show all values where at least 1 value correspondents the selected value whitin a diminsion??

Glad it helped .

Partner
Partner

Re: Show all values where at least 1 value correspondents the selected value whitin a diminsion??

One more question, but it is not that important, so only if it is not much work.

I probably can't hide that column in sense with still getting the same results?

Partner
Partner

Re: Show all values where at least 1 value correspondents the selected value whitin a diminsion??

Is it possible to add another column where i ignore the selection and see only the selected value in this case 101 in every row.

In my table I have a short and a long barcode, i want to sort on that long barcode. But if i know how i can ignore the selection on 1 dimension or expression I think I can figure it out.

Many thanks felipedl