|B||01-01-08 00:00:00||04:03:11 00:00:00|
I have above criteria in database, with Branch A as open still, and Branch B closed.
In the Qlikview, user can select Year and Month from listbox. He can choose multiple Years or Months from listbox.
Now here, I want to show only those Branch(s) for which below criteria satisfies:
if (OpeningDate is less than Year and Month) and (ClosingDate is greater than (Year and Month or NULL))
it should show me Branch
it should not show
Can anyone translate it to expressions? Thanks in advance.