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
Where do you want that? If you create a list box for that field, you get all of them.
i have created a straight table
in that want that
i am doing by taking one and sellting one by one
but i want all a time using clm_no
What are your dimension and expression?
dimension are
clm_no
name
end_date
city
and expression i have kept 1
I am not sure really, What are you trying to achieve. Would you let me know what is target Straight Table. Please provide sample input and Expected O/P
Why not simple, Count(nodistinct clm_no)
i only want this clm_no
12345
1256
1568
12587
Then Why not this?
If(WildMatch(clm_no,'12345','1256','1568','12587')) as clm_no
OR
Count({<clm_no = {'12345','1256','1568','12587'} >} Target)
in dimension or in expression
Use Dimension if required, I really don't now what are you trying to acheive Can you please share the sample