Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Check if solve your needs
Hi,
Please find attached file for solution.
Regards,
Jagan.
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
HI
PFA
Hi Mayil ,
Thanks 4 Help
i want data like singapore to apply logic on dimension level purposefully ...
Thanks
Harshal