Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master II

Set Analysis with Times

Hi All,

I have the following expression, I get no errors and it returns results.

The problem is the times, how should I be writing this with Set Analysis, I should see only transactions between 07:30 and 17:30, but with the below expression it shows all times for the max date

NUM(

  SUM(

  {<

  Date          = {"$(=MAX(Date))"},

  [TrxType]     = {'D'},

  ActionID      = {'PICKCASE'},

  OneMinBucket  = {"$(= '>=' & '07:30' & '<=' & '17:30')"},

  OperativeName = {"=SUM($(metric2)) <> 0"}

  >}

  $(metric2))

,'#,##0')

If I have the following in a text object it returns the correct results

=concat({<Date  = {'28/02/2017'},OneMinBucket = {"$(= '>=' & '07:30' & '<=' & '08:30')"}>}OneMinBucket,',')

6 Replies
Highlighted

So it works in text box, but not in a chart? That's strange, would you be able to share a sample?

Highlighted
Master II
Master II

Unfortunately I can't share the Application

Highlighted

Screenshots?

Highlighted
Master II
Master II

Apologies, it does work, the issue I have is with something else.

I need to display all times between 07:30 and 17:30 regardless of a transaction happening with each OneMinuteBucket.

I need to limit my dimension to show all minutes between the 2 times

Highlighted

I am not sure I am understanding anything Alan.... If you are able to neither share a sample or sample data or something else that I can understand... then I would let someone else help you out

Best,

Sunny

Highlighted
Champion II
Champion II

Does this work on the ListBox?

'>=07:30<=17:30'


if it works in your listbox, then it should work in set analysis as well

NUM(

  SUM(

  {<

  Date          = {"$(=MAX(Date))"},

  [TrxType]     = {'D'},

  ActionID      = {'PICKCASE'},

  OneMinBucket  = {">=07:30<=17:30"},

  OperativeName = {"=SUM($(metric2)) <> 0"}

  >}

  $(metric2))

,'#,##0')