Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gorterzelf7
Partner - Creator
Partner - Creator

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
felipedl
Partner - Specialist III
Partner - Specialist III

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

View solution in original post

6 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

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

gorterzelf7
Partner - Creator
Partner - Creator
Author

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
Partner - Specialist III
Partner - Specialist III

Glad it helped .

gorterzelf7
Partner - Creator
Partner - Creator
Author

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
Partner - Creator
Partner - Creator
Author

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
Contributor II
Contributor II

Hi Felipedl,

Can we achieve this in dimension instead of measure

 

Thanks