Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master
‎2014-08-15 07:13 AM

How to make Qlik view stock Qty real time update ?

I have a inventory file raw data file in txt format . I use QV to read and reload daily in the morning.

Many time staff check stock have stock but when check the account system items just sold by some one.

My question how to make it real time link stock Qty inform real time update ? Meaning if some one sold the items . My account system will generated the raw data file and Qlik view will reload. So data is updated real time.

Any idea how to achieve this ?

211 Views
0 Likes
1 Reply
Colin-Albert
MVP
MVP
‎2014-08-15 07:22 AM

Your data is loading for a txt file, so the update frequency in the current system will be limited by the frequency that the txt data is updated.

How often can you refresh the txt file?

Can you connect directly to the database and set the server to reload more frequently?

Direct Discovery may be an option if you can connect directly to the database.

There are some limitations on the direct discovery functionality and the options available depend on which version and SR you are using. The FAQ below gives more details.

http://community.qlik.com/docs/DOC-6917

110 Views
0 Likes