Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I need your help in Set Analysis, as mention below m using the expression to calculate member count on the basis of date comparison, the syntax which i am using:
this expression is working fine if i select single month, but not working when i use month as a dimension as when i use month as dimension above mention "monthend or monthstart" expression takes only one value i.e. for jan start & end date. Because of this in my output reports it gives the value for jan in all rest of the month as mention below & highlighted in red, the value 128 is for jan only but its coming in all month:
Can you try pls
Count( Aggr( formula , Dimension))
where dimensions will be Months.
Regards
Vikas
Can you try same expression by using '1' instead of '$' ?
try something like:
Count ( <Your set analysis> Distinct Total <MonthField> MEM_USERID)
Hello Tresesco,
What do you mean by Total <MonthField>
Can you explain..
Hi,
Total <MonthField> would disregard your month dimension which is there in your chart. For better understanding, have a look at the attached sample. Hope that helps you understand.
This doesnt work, Please chk & let me know
Another point just noticed.
While you are using min()/max() functions, the similar set analysis has to be included there too, I guess. Could you please share example app with sample data?
You should use the " instead of ' when using set analysis with >=< sign.
For example you should write
ENG_ACTDATE={">=$(=MonthStart(Min(COMMON_DATE)))"}
instead of
ENG_ACTDATE={'>=$(=MonthStart(Min(COMMON_DATE)))'}
Try this to solve your problem. If this doesn't I will check the rest of the formula.
Hi Tresesco,
please find the attached sample data with qvw. in a straight table there are two expression one is with Set Analysis & second one is with If Condition the output using if condition is correct and i want the same with set analysis.