topic Re: all data in QlikView

all data

sagarrahul — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: all data

tresB — Wed, 21 Sep 2016 06:45:39 GMT

Where do you want that? If you create a list box for that field, you get all of them.

Re: all data

sagarrahul — Wed, 21 Sep 2016 06:52:56 GMT

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

Re: all data

tresB — Wed, 21 Sep 2016 06:55:05 GMT

What are your dimension and expression?

Re: all data

sagarrahul — Wed, 21 Sep 2016 06:58:29 GMT

dimension are

clm_no

name

end_date

city

and expression i have kept 1

Re: all data

Anil_Babu_Samineni — Wed, 21 Sep 2016 07:01:41 GMT

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)

Re: all data

sagarrahul — Wed, 21 Sep 2016 07:06:29 GMT

i only want this clm_no

12345

1256

1568

12587

Re: all data

Anil_Babu_Samineni — Wed, 21 Sep 2016 07:10:43 GMT

Then Why not this?

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

Count({<clm_no = {'12345','1256','1568','12587'} >} Target)

Re: all data

sagarrahul — Wed, 21 Sep 2016 07:11:45 GMT

in dimension or in expression

Re: all data

Anil_Babu_Samineni — Wed, 21 Sep 2016 07:12:58 GMT

Use Dimension if required, I really don't now what are you trying to acheive Can you please share the sample

Re: all data

sagarrahul — Wed, 21 Sep 2016 07:18:54 GMT

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

Re: all data

Anil_Babu_Samineni — Wed, 21 Sep 2016 07:21:35 GMT

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?

Re: all data

sagarrahul — Wed, 21 Sep 2016 07:24:24 GMT

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

Re: all data

Anil_Babu_Samineni — Wed, 21 Sep 2016 07:27:37 GMT

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)

Re: all data

sagarrahul — Wed, 21 Sep 2016 08:54:36 GMT

there are about 100 clm no

can it handle the load

another method to do it can u help it

Re: all data

Digvijay_Singh — Wed, 21 Sep 2016 09:30:52 GMT

try like this -