topic Set Analysis with Times in QlikView

Set Analysis with Times

rustyfishbones — Mon, 13 Mar 2017 11:19:25 GMT

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

Re: Set Analysis with Times

sunny_talwar — Mon, 13 Mar 2017 11:44:37 GMT

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

Re: Set Analysis with Times

rustyfishbones — Mon, 13 Mar 2017 11:46:53 GMT

Unfortunately I can't share the Application

Re: Set Analysis with Times

sunny_talwar — Mon, 13 Mar 2017 11:54:54 GMT

Screenshots?

Re: Set Analysis with Times

rustyfishbones — Mon, 13 Mar 2017 12:10:50 GMT

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

Re: Set Analysis with Times

sunny_talwar — Mon, 13 Mar 2017 12:13:50 GMT

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

Re: Set Analysis with Times

vinieme12 — Mon, 13 Mar 2017 13:12:19 GMT

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