8 Replies Latest reply: Jul 31, 2015 12:55 PM by Sunny Talwar

# Gauge of todays data

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.

Chris

• ###### Re: Gauge of todays data

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

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

• ###### Re: Gauge of todays data

Hi stalwar1

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

• ###### Re: Gauge of todays data

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)

• ###### Re: Gauge of todays data

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

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

• ###### Re: Gauge of todays data

What exactly are you trying to do???

• ###### Re: Gauge of todays data

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

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

• ###### Re: Gauge of todays data

For gauge, try this may be:

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

• ###### Re: Gauge of todays data

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)