Gauge of todays data

[#1]

HI there

Hope you are all well?

I have data that basically is a historic record of total orders vs invoiced orders, as such

date               qty_ord     qty_inv

01/07/2015     100          100

02/07/2015     100          90

and so on,

I want to create a multi guage screen that shows the fullfilment % ( qty_inv / qty_ord) for today, this week and this month however I can't seem to wrap my head around how to isolate just todays/this weeks data in the gauge.

Thanks in advance.

Chris

[sunny_talwar]

Use set analysis to filter the data to show one date. For today you will do something like this:

{<Date = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>}

[#3]

Hi sunindia‌

Thanks for coming back to me, sorry I am new to qlik, would I put that in the load script or would I put it in a measure?

Thanks

[sunny_talwar]

This would go in your expression. For instance you want to sum today sales, then your expression would be:

Sum({<Date = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>} Sales)

[#5]

Apologies, this is probably something really obvious

I have tried

({} sum(qty_inv) /

sum(qty_ord) )

but that did not work either

Thanks

Christopher Nash | Systems Analyst

Phone: 01274 88 55 21

Email: christopher.nash@trycare.co.uk

Post: Trycare Ltd, Station Road, Bradford, West Yorkshire, BD14 6JA

Web: trycare.co.uk <http://www.trycare.co.uk>

[sunny_talwar]

What exactly are you trying to do???

[#7]

I have a data that is comprised of transactions, that show in essence

date part qty_ordered qty invoiced

01/01/2015 15a 10 9

01/01/2015 16a 11 8

02/01/2015 15a 10 10

etc etc

from 01/01/2015 till today (always updates with the current date)

What I want to do is build a dashboard, that has a bargraph of % fulfilled

(qty_inv/qty_ord) by dates, but have a gauge of today's %.

I appreciate that if a filter is in place that excludes todays data it will

show 0.

Thanks

Chris

Christopher Nash | Systems Analyst

Phone: 01274 88 55 21

Email: christopher.nash@trycare.co.uk

Post: Trycare Ltd, Station Road, Bradford, West Yorkshire, BD14 6JA

Web: trycare.co.uk <http://www.trycare.co.uk>

[sunny_talwar]

For gauge, try this may be:

Sum({<Date = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>} qty_inv)/Sum({<Date = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>} qty_ord)

[sunny_talwar]

For bar chart to exclude today, try this may be:

Sum({<Date = e({< Date = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>})>} qty_inv)/Sum({<Date = e({< Date = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>})>} qty_ord)