- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
how to find one value in a dimension in the chart
Hi, I want to create a chart for one dimension with multiple values, but only check if it with one specific value.
One A with multiple B
A | B |
123 | 1100 |
123 | 1200 |
123 | 1400 |
123 | 1500 |
456 | 1100 |
456 | 1600 |
I need a table shown like this
A | with 1200 | with 1600 |
123 | Y | N |
456 | N | Y |
- Tags:
- qlikview_scripting
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I've used the expression below in my With 1200 column
IF(count({<B={'1200'}>}B), 'y', 'n')
See attachment
Qlik Community MVP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@palomaliang are you looking for ?
in dimension A
Measures
with 1200: if(count({<B={1200}>} A)>0,'Y','N')
with 1600:if(count({<B={1600}>} A)>0,'Y','N')
output:
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I've used the expression below in my With 1200 column
IF(count({<B={'1200'}>}B), 'y', 'n')
See attachment
Qlik Community MVP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@palomaliang are you looking for ?
in dimension A
Measures
with 1200: if(count({<B={1200}>} A)>0,'Y','N')
with 1600:if(count({<B={1600}>} A)>0,'Y','N')
output:
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@palomaliang with A as dimension use below expression
// With 1200
=if(index(Concat(DISTINCT B),'1200'),'Y','N')
// With 1600
=if(index(Concat(DISTINCT B),'1600'),'Y','N')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Vegar, it works.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Taoufiq_Zarra, it works.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Kush, but it's not all right.