Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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.

Thanks in advance.

Chris

Tags (1)
8 Replies
MVP
MVP

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

Not applicable

Re: Gauge of todays data

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

MVP
MVP

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)

Not applicable

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

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>

MVP
MVP

Re: Gauge of todays data

What exactly are you trying to do???

Not applicable

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

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>

MVP
MVP

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)

MVP
MVP

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)