Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello people,
I'm stuck in middle and please read my problem below.
I have added a measure in Master items which gives me results based on the condition like "Match" or "No match".
My requirements:
1. I want to have a filter on master Item (Check Compare). I can currently sort on CheckCompare column but not filter however I can filter Source_ID,Source_Period columns
2. I want to have count of the results in separate chart from Master item.. like count of "Match" and Count of "No Match"
I have attached QVF file here for ur reference...thanks in advance 🙂
Try this as your master dimension
=aggr(If(Sum(Aggr(If(Match(Source_Combo, Dest_Combo), 1, 0), Source_Combo, Dest_Combo)) > 0, 'Match', 'No Match'),Source_Combo)
Regarding being able to filter, you defined a master measure (CheckCompare) not a dimension; just define a master dimension:
=If((Aggr(If(Match(Source_Combo, Dest_Combo), 1, 0), Source_Combo, Dest_Combo)) > 0, 'Match', 'No Match')
To be able to count, just use the master dimension I mentioned above and count on whichever elements you want (e.g. Source_ID)
Try the formula I gave you before
Hi,
I'm able to define master dimension however rows are duplicated... can u check ?
Remove the Check Compare measure
I have removed Master comparison however still the duplicates are there
Try this as your master dimension
=aggr(If(Sum(Aggr(If(Match(Source_Combo, Dest_Combo), 1, 0), Source_Combo, Dest_Combo)) > 0, 'Match', 'No Match'),Source_Combo)
Thank you.. it worked for me... 😀 I could create master dimension and filter option
But I'm not sure how to get count of Matches/no matches ... would really appreciate if you can guide me
Can you please explain exactly what you need? I didn't understand completely from your first post