Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hiii community
i am having problem in getting data of all clm_no at a time
these are my fields
clm_no
name
end_date
city
now i want all
these are my clm_no
eg :
1234
4569
1456
1452
i wnat all data of field
how can i get it
i want data of this clm_no only
if i give this clm_no then all data should be ssen
1234
4569
1456
1452
clm_no | name | end_date | city |
1234 | ert | 15/02/15 | mumbai |
4569 | fgh | 12/02/15 | delhi |
1456 | hhh | 14/02/15 | chennai |
1452 | hhiu | 18/02/15 | maharahtra |
Your table has four rows, You will get four only
Then use List box - use Clm_no then you will get those only
QlikCommunity Tip: How to get answers to your post?
in dimension i have added this feilds
clm_no
name
end_date
city
but i dnot want all clm_no but i want only below clm in my table
1234
4569
1456
1452
I Assume, You are expecting this
Goto List Box -- Choose Expression
Then Write like below,
=If(WildMatch(clm_no,'12345','1256','1568','12587'),clm_no)
there are about 100 clm no
can it handle the load
another method to do it can u help it
try like this -