Anonymous
Not applicable
2018-03-16
09:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to include only one value in a dimension
Hello Everyone
i have one requirment in which i want to exclude some values from the dimesnion. Let say i have one dimesnion called Name . In the Name there are value like Mark, Eric, Shaun and Jack. So my requirment is that i should write formula in such a way that it should only include Jack . I am new to qlikview. Any help would be highly appreciated
Regards
Lokender
1,801 Views
2 Replies
ychaitanya
Creator III
2018-03-16
02:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you can use something like this.
Wildmatch(Fieldname,'*Search Substring*')
ex : if(Wildmatch(Name,'*Jack*')>0,Name) as Expression in your listbox or field derivation
1,718 Views
Digvijay_Singh
MVP
2018-03-16
02:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Where exactly you are trying this?
If it is in the measure expression - you may do something like this -
Sum({<Name={'Jack'}>}Value)
It will do sum for the Name='Jack' only.
1,718 Views