topic Status Box! in QlikView

Status Box!

Wed, 25 Nov 2020 16:16:04 GMT

Date	A end count	B end count	C end count
9/28/2016	143	172	28
9/28/2016	127	173	37
9/29/2016	120	219	41
9/30/2016	245	219	20
10/3/2016	75	220	20
10/4/2016	0	223	0

Hi!!

this is the same data for my question.this is a task tracker. and work comes into my tasktracker as i am working. so I just log the number of tasks that I have on my queue at the end of the day. so that the next day, i can start with something that has most volume in the task tracker.

what i want to do is make a small box that contains the most recently logged end count for the three jobs.

so today is 5th Oct and I did not log any anything. but the most recent task tracker log says that i have 0 task for project A 223 tasks for project B 0 tasks for project C

I want them to float in a box with caption name project A and contents with larger sized numbers.

Please help!!

Thank you in advance!!

Re: Status Box!

sunny_talwar — Thu, 06 Oct 2016 01:31:50 GMT

You are looking to display the most recent information for the three projects in a text box object? Is that what you are looking to get?

Re: Status Box!

Thu, 06 Oct 2016 02:17:33 GMT

Yes! exactly!

they are the numbers I want to have pop out so that it is easy to tell which of the three I have to prioritize.

it will be literally a status box

Re: Status Box!

Thu, 06 Oct 2016 02:19:06 GMT

for our dataset. it will look like this!

Re: Status Box!

sunny_talwar — Thu, 06 Oct 2016 02:19:43 GMT

Status box? What is a status box? I am not sure I understand

Re: Status Box!

sunny_talwar — Thu, 06 Oct 2016 02:21:58 GMT

May be three text box objects like this::

='Project A' & Chr(10) & Sum({<[Project Name] = {'A'}, Date = {"$(=Date(Max(Date), 'M/D/YYYY'))"}>} Count)

='Project B' & Chr(10) & Sum({<[Project Name] = {'B'}, Date = {"$(=Date(Max(Date), 'M/D/YYYY'))"}>} Count)

='Project C' & Chr(10) & Sum({<[Project Name] = {'C'}, Date = {"$(=Date(Max(Date), 'M/D/YYYY'))"}>} Count)

Re: Status Box!

sunny_talwar — Thu, 06 Oct 2016 02:26:56 GMT

Sample attached

Re: Status Box!

Thu, 06 Oct 2016 02:32:03 GMT

For this dataset, I do not have column named Project Name.

like the above dataset that I provided, the name of the column is just A end count, B end count, C end count.

Re: Status Box!

Thu, 06 Oct 2016 02:33:43 GMT

thank you for the sample attached! but the dataset looks exactly like I provided!

Re: Status Box!

sunny_talwar — Thu, 06 Oct 2016 02:33:47 GMT

Then try these expressions:

='Project A' & Chr(10) & Sum({<Date = {"$(=Date(Max(Date), 'M/D/YYYY'))"}>} [A end count])

='Project B' & Chr(10) & Sum({<Date = {"$(=Date(Max(Date), 'M/D/YYYY'))"}>} [B end count])

='Project C' & Chr(10) & Sum({<Date = {"$(=Date(Max(Date), 'M/D/YYYY'))"}>} [C end count])

Re: Status Box!

sunny_talwar — Thu, 06 Oct 2016 02:35:57 GMT

Updated sample

Re: Status Box!

Thu, 06 Oct 2016 02:45:33 GMT

Hi Sunny, there are multiple tables in my dashboard and each have different Date name.

for this, it is Project.Date

='Project A' & Chr(10) & Sum({<Project.Date= {"$(=Date(Max(Project.Date), 'M/D/YYYY'))"}>} [A end count])

do you think this is correct? I am trying out few things, not working yet.

and can I remove Chr()?? what does it do??

Re: Status Box!

sunny_talwar — Thu, 06 Oct 2016 02:47:53 GMT

Expression looks good to me. Chr(10) just pushes the number to the next row

Re: Status Box!

Thu, 06 Oct 2016 02:50:21 GMT

It is working!!! thank you so much Sunny!!!!!