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

[gorterzelf7]

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

[felipedl · Accepted solution]

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 following

[gorterzelf7]

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:-)

[felipedl]

Glad it helped .

[gorterzelf7]

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?

[gorterzelf7]

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‌

[mukesh19]

Hi Felipedl,

Can we achieve this in dimension instead of measure

Thanks