Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarrahul
Creator
Creator

all data

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

15 Replies
sagarrahul
Creator
Creator
Author

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_nonameend_datecity
1234ert15/02/15mumbai
4569fgh12/02/15delhi
1456hhh14/02/15chennai
1452hhiu18/02/15maharahtra
Anil_Babu_Samineni

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?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sagarrahul
Creator
Creator
Author

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

Anil_Babu_Samineni

I Assume, You are expecting this

Goto List Box -- Choose Expression

Capture.PNG

Then Write like below,

=If(WildMatch(clm_no,'12345','1256','1568','12587'),clm_no)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sagarrahul
Creator
Creator
Author

there are about 100 clm no

can it handle the load

another method to do it can u help it

Digvijay_Singh

try like this -