Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

Master II
Master II

Unfortunately I can't share the Application

Screenshots?

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

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

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