Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
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')