topic Re: Dashboard changing in real time in QlikView

Dashboard changing in real time

richard_chilvers — Mon, 05 Jan 2015 15:27:43 GMT

I would like to create a dashboard where the objects will vary every time the data is reloaded.

My data would be sales of products, and the dashboard would show only products which have sold 100 items or more today.

Each product would show as an object (eg. gauge chart) giving details of sales today, last week, YTD. So the dashboard might show no products, or quite alot ! It is an overview of how sales are going.

But I do not want to restrict the data on the script because I will have tables of information for all products elsewhere in the model.

Any thoughts?
Thanks

Re: Dashboard changing in real time

Mon, 05 Jan 2015 15:38:07 GMT

Hi,

in my opinion: When there is no product quantitiy > 100 sold in 1 day then display a relevant message on screen.

But first make a table in loadscript with the products which are sold more than 100 times the last day and display them (in a trellis?) graph or barchart....

good luck

Re: Dashboard changing in real time

avinashelite — Mon, 05 Jan 2015 15:46:40 GMT

Hi Richard,

To get the real time data go with DIRECT DISCOVERY concept to achieve this, please refer this document.

Re: Dashboard changing in real time

richard_chilvers — Tue, 06 Jan 2015 09:10:34 GMT

Thanks for your reply.

But getting the real time data is not my issue.

What I'd like help with is how to create a dashboard page which might show 1 product or might show 15 (or more) products, depending on what is selling well.

Regards

Re: Dashboard changing in real time

Tue, 06 Jan 2015 09:40:19 GMT

Hi Richard,

you can show them in a graph (barchart) and show them when more than 100 are sold. with Product as a dimension and sum(QTY) as an expression.... or I'am missing the point?

hth

Re: Dashboard changing in real time

richard_chilvers — Tue, 06 Jan 2015 10:09:09 GMT

Hi Felix

Its my fault - I haven't clearly given the full story ! Otherwise I would probably use Dimension Limits in the way you suggest.

What I want to show on my dashboard is only those products that are selling well (eg. more than 100). But for each of these products I want to show other details, for example what are the most popular sizes, how many sold yesterday, last week, last month, compared with targets etc.

So each product would have its own 'chart' on the dashboard.

Any ideas are welcome !

Thanks

Re: Dashboard changing in real time

Tue, 06 Jan 2015 10:18:50 GMT

Hi,

sounds like you have to make a list (box) of these particular products and let the users select 1 and show the details like you want.

hth

Re: Dashboard changing in real time

richard_chilvers — Tue, 06 Jan 2015 10:32:03 GMT

Yes - that would work quite well.

Regards

Re: Dashboard changing in real time

Tue, 06 Jan 2015 11:01:20 GMT

good to know that in addition of a listbox you can add all kind of info/expressions for a quick overview of the products... lots of possibilities!

goodluck!