Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
richard_chilvers
Specialist
Specialist

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

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.

avinashelite

Hi Richard,

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

richard_chilvers
Specialist
Specialist
Author

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

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
Specialist
Specialist
Author

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

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
Specialist
Specialist
Author

Yes - that would work quite well.

Regards

Not applicable

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