Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use set analysis to filter the data to show one date. For today you will do something like this:
{<Date = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>}
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
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)
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>
What exactly are you trying to do???
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>
For gauge, try this may be:
Sum({<Date = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>} qty_inv)/Sum({<Date = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>} qty_ord)
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)