topic Re: Re: straight table issue need solution... in QlikView

straight table issue need solution...

Thu, 24 Oct 2013 10:48:30 GMT

please provide solution for following scenario i'm facing...

1. I need the count of ID with eliminitation of blank values in InternalID ( without supressing Null )

2. I need to count the number of those whose ID is having more than 1 INTERNAL ID (E.G. ID 3 CONTAINS 111, 333).

3 I dont want to show the INTERNALID filed in both expression and dimension level as wel..

find below demo.qvw ..

Thanks in advance...

thanks & regards,

Harshal Patil

Re: straight table issue need solution...

swuehl — Thu, 24 Oct 2013 10:55:58 GMT

Try this as expression in a straight table with dimension ID:

=count({<InternalID = {">0"}>}InternalID)

edit: And if you want to count the IDs with more than 1 InternalIDs:

=count({<ID = {"=count({<InternalID = {'>0'}>}InternalID)>1"}>} distinct ID)

Re: straight table issue need solution...

Clever_Anjos — Thu, 24 Oct 2013 11:03:12 GMT

Check if solve your needs

Re: straight table issue need solution...

jagan — Thu, 24 Oct 2013 11:04:01 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

Re: straight table issue need solution...

Mon, 28 Oct 2013 12:33:52 GMT

Thanks All.....

I want to remove the id's which are having multiple loc's.The sample data as below.

e.g. : Id Location count

101 US 1

102 Uk 1

101 India 1

102 - 1

105 singapore 1

The estimated result should be in :

105 Singapore 1

I want remove the id's which are allocated to multiple loc's and which are having blank values.

Thanks & Regards,

Harshal patil

Re: Re: straight table issue need solution...

MayilVahanan — Mon, 28 Oct 2013 13:18:22 GMT

PFA

Re: straight table issue need solution...

Mon, 28 Oct 2013 13:37:38 GMT

Hi Mayil ,

Thanks 4 Help

i want data like singapore to apply logic on dimension level purposefully ...

Thanks

Harshal