Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

straight table issue need solution...

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

6 Replies
Highlighted
MVP
MVP

Re: straight table issue need solution...

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)

Highlighted
Employee
Employee

Re: straight table issue need solution...

Check if solve your needs

Highlighted
MVP & Luminary
MVP & Luminary

Re: straight table issue need solution...

Hi,

Please find attached file for solution.

Regards,

Jagan.

Highlighted
Not applicable

Re: straight table issue need solution...

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

Highlighted

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

HI

PFA

Highlighted
Not applicable

Re: straight table issue need solution...

Hi Mayil ,

Thanks 4 Help

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

Thanks

Harshal