Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Gabbar
Specialist
Specialist

Multiple Level In Set Analysis

Gabbar_0-1664720237911.png

I have different date fields with corresponding different Ref ID, with same license Number(It is just an SS for a particular license number for explaination). 
Now there are Criteria for dates and also for current license Flag.
So what i need in 1st step is that if the my date criteria satisfies any of the dates, this would give me an output of license number, Now on 2nd step i want to check if it is active or not with current license flag = 1, and at 2nd 1st step dates shouldnt matter.
Like in above case if dates condition is satisifed by one or more ref ID, then it should give me the license number as ref ID number 4 has current license flag = 1 with same license number.

 

 

Please Help,
Thanks 

Labels (2)
4 Replies
deepanshuSh
Creator III
Creator III

Is it like you want a single measure/dimension for all the above computations or different for different logics. 

In either of the case you need to use if and else condition with the set analysis as core output. 

Trial and error is the key to get unexpected results.
Gabbar
Specialist
Specialist
Author

will you please explain it more, I did not get what you are trying to convey.

deepanshuSh
Creator III
Creator III

I am saying please elaborate more on what expression that you are trying to create and if you are trying to refer to same dimension multiple times or differnt dimensions in the set analysis?

Trial and error is the key to get unexpected results.
Gabbar
Specialist
Specialist
Author

different dimensions, at separated occasion.