Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
larsenrennie
New Contributor

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

2 Replies
ychaitanya
Contributor III

Re: How to include only one value in a dimension

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

Digvijay_Singh
Honored Contributor III

Re: How to include only one value in a dimension

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.