Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

richard_chilvers
Contributor III

Dashboard changing in real time

Hi

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

8 Replies
Not applicable

Re: Dashboard changing in real time

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

F.

Re: Dashboard changing in real time

Hi Richard,

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

Highlighted
richard_chilvers
Contributor III

Re: Dashboard changing in real time

Hi

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

Not applicable

Re: Dashboard changing in real time

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

F.

richard_chilvers
Contributor III

Re: Dashboard changing in real time

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

Not applicable

Re: Dashboard changing in real time

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

F.

richard_chilvers
Contributor III

Re: Dashboard changing in real time

Yes - that would work quite well.

Regards

Not applicable

Re: Dashboard changing in real time

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!

F

Community Browser