Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
will you please explain it more, I did not get what you are trying to convey.
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?
different dimensions, at separated occasion.