- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What should be set expression to restrict dimension values one field but not in other field ?
Hi All ,
I have list of around 50 employee headed by 5 person .
My requirement is to track sales ID by some 10 employee for any given date range .
But my set expression reduces the list of employee than needed .
I tried expression with pivot , but in vain
1) Count( DISTINCT {<TRANS={'B'},TYPE={'Music'},DATEE={">=$(=Date(eStartDate))<=$(=Date(eEndDate))"} >}ACTION_ID)
2) Count( DISTINCT {<NAME= {'Karole Peskett','Nikolaos Meedendorpe','Reg Andrzejak','Sigismondo Rudram','Antonius Beatens','Axel Este','Barny Chown'}, TRANS={'B'},TYPE={'Music'},DATEE={">=$(=Date(eStartDate))<=$(=Date(eEndDate))"} >}ACTION_ID)
With both above expression , i could not get desired , below result
Basically i need a set expression should give me the count of distinct ACTION_ID for given set of names against above Heads .
Thanks & Regards
Shekar
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this expression
Count(DISTINCT {<NAME= {'Karole Peskett','Nikolaos Meedendorpe','Raviv O''Connell', 'Reg Andrzejak','Sigismondo Rudram','Antonius Beatens','Axel Este','Barny Chown'}, TRANS={'B'},TYPE={'Music'},DATEE={">=$(=Date(eStartDate))<=$(=Date(eEndDate))"} >}ACTION_ID) + Sum({<NAME= {'Karole Peskett','Nikolaos Meedendorpe','Raviv O''Connell', 'Reg Andrzejak','Sigismondo Rudram','Antonius Beatens','Axel Este','Barny Chown'}>} 0)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
attached qvw
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@sunny_talwar
Hi Sunny Bhai , please help with set expression
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@tresesco ... Any help ..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be just modifying the quotes like:
Remove the double quotes and add one more single quote as highlighted in red
Count( DISTINCT {<NAME= {'Karole Peskett','Nikolaos Meedendorpe','Raviv O''Connell',
'Reg Andrzejak','Sigismondo Rudram','Antonius Beatens','Axel Este','Barny Chown'},
TRANS={'B'},TYPE={'Music'},DATEE={">=$(=Date(eStartDate))<=$(=Date(eEndDate))"} >}ACTION_ID)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Tresesco ,
Thanks for reply .
I tried your expresssion as well
Count( DISTINCT {<NAME= {'Karole Peskett','Nikolaos Meedendorpe','Raviv O''Connell',
'Reg Andrzejak','Sigismondo Rudram','Antonius Beatens','Axel Este','Barny Chown'},
TRANS={'B'},TYPE={'Music'},DATEE={">=$(=Date(eStartDate))<=$(=Date(eEndDate))"} >}ACTION_ID)
But still its not working , out of 8 names from set expression only 5 is coming ..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I guess that is because of the date range selected.... I changed the end date to be 02-05-2019 and I am seeing this now
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank You Sunny Bhai for replying .
But my requirement is that , irrespective of date range for given set of Names , ACTION id count should be tracked .
Let say for a given date range there is no ACTION id for most of the given set of names , then still my chart show show their names with null or 0 as expression values .
I am not sure how to do it , even through i have explicitly given the names in set modifier
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this expression
Count(DISTINCT {<NAME= {'Karole Peskett','Nikolaos Meedendorpe','Raviv O''Connell', 'Reg Andrzejak','Sigismondo Rudram','Antonius Beatens','Axel Este','Barny Chown'}, TRANS={'B'},TYPE={'Music'},DATEE={">=$(=Date(eStartDate))<=$(=Date(eEndDate))"} >}ACTION_ID) + Sum({<NAME= {'Karole Peskett','Nikolaos Meedendorpe','Raviv O''Connell', 'Reg Andrzejak','Sigismondo Rudram','Antonius Beatens','Axel Este','Barny Chown'}>} 0)
- « Previous Replies
-
- 1
- 2
- Next Replies »