Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 -