straight table issue need solution...

[#1]

Hi

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

[swuehl]

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)

[Clever_Anjos]

Check if solve your needs

[jagan]

Hi,

Please find attached file for solution.

Regards,

Jagan.

[#5]

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

[MayilVahanan]

HI

PFA

[#7]

Hi Mayil ,

Thanks 4 Help

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

Thanks

Harshal