Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
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
sunny_talwar

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

rustyfishbones
Master II
Master II
Author

Unfortunately I can't share the Application

sunny_talwar

Screenshots?

rustyfishbones
Master II
Master II
Author

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

sunny_talwar

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

vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.