Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Simple expression conversion required.

BranchOpeningDateClosing Date
A15-10-12 00:00:00NULL
B01-01-08 00:00:0004: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.

I am showing data in Pivot table, like below:qkview.png

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))
then

    it should show me Branch

else

   it should not show

Can anyone translate it to expressions? Thanks in advance.

Community Browser