Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview Support 64 Bit OS?

i studied the BI features of the qlikview,

but i m not able to find the following question's answers..

-Slicing and Dicing of data

-Capabilities to cater ad-hoc queries

-Implementation of cubes

-Thresholds alerts

-Capabilities to develop reusable data elements (e.g. webparts)

-Export functionality (PDF)

-Email functionality

-Scheduling functionality

-Better UI

-Capabilities for mobile, i-pad reporting

-Integration with .Net,MS Office,MS Sharepoint

-Ease of use

-Response time, Memory consumption

-Short build and deploy time

-Max. of Data Handling(2 TB or more)

-Tech support(24 X 7)

-64 Bit OS support



if possible then pls give me answers as soon as possible with example if applicable.

i am using personal edition.

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

-Slicing and Dicing of data
Yes

-Capabilities to cater ad-hoc queries
Depends on what you mean by ad-hoc queries. Reporting is very dynamic, but users do NOT run queries against your database. They instead filter data that you've already loaded into memory.

-Implementation of cubes
QlikView does NOT use (or need) data cubes internally. It works in a different, and I personally think superior way.

-Thresholds alerts
Yes

-Capabilities to develop reusable data elements (e.g. webparts)
Depends on what you mean by reusable elements. There are a lot of reusable elements, but I'm not familier with webparts.

-Export functionality (PDF)
Yes

-Email functionality
Yes

-Scheduling functionality
Yes, with QlikView Publisher.

-Better UI
Better than what? I like the UI just fine.

-Capabilities for mobile, i-pad reporting
Yes, but I think there's room for improvement here. The native iPad client I think doesn't take good advantage of the larger screen. You can publish in AJAX and pull it up in Safari on the iPad, but it doesn't work particularly well with the touch screen interface. They ARE actively working on it, though.

-Integration with .Net,MS Office,MS Sharepoint
Mmmm, not sure. You can export to and import from Excel. I know I've seen "sharepoint" mentioned many times on the forum. Not sure about .Net.

-Ease of use
For users, it's as easy as you make it for them as a developer. Generally pretty easy. For developers, I consider it fairly easy, though I think there are some definite areas for improvement.

-Response time, Memory consumption
Depends on how much data you have and how complicated you make your charts. Generally speaking, most of my real applications are near instantaneous or sub-second. Some of the more complicated ones are longer, with my absolute wost charts taking many seconds to finish calculating. For memory consumption, figure on about 10x compression of your raw data, but then add back in another 5-10% for every concurrent user of the data. Since analysis is done entirely in memory, you need that much RAM. You can't afford to swap to disk.

-Short build and deploy time
Yes

-Max. of Data Handling(2 TB or more)
I believe it was designed for gigabyte-scale databases. However, I am not aware of any technical limitations (other than available hardware) that would prevent you from using it on terabyte-scale databases. I think windows server maxes out at 2 TB, but in practice, you can run a lot of different applications on a lot of different servers to get around even that limitation. Should be doable, but I'd want to hear from people actually running that much data before making a commitment. Our shop probably has only 100 GB or less, so we don't count.

-Tech support(24 X 7)
I don't know tech support's hours. I've never called them. I email. But for most issues, I recommend the forum. It's very active and helpful.

-64 Bit OS support
Yes

View solution in original post

2 Replies
johnw
Champion III
Champion III

-Slicing and Dicing of data
Yes

-Capabilities to cater ad-hoc queries
Depends on what you mean by ad-hoc queries. Reporting is very dynamic, but users do NOT run queries against your database. They instead filter data that you've already loaded into memory.

-Implementation of cubes
QlikView does NOT use (or need) data cubes internally. It works in a different, and I personally think superior way.

-Thresholds alerts
Yes

-Capabilities to develop reusable data elements (e.g. webparts)
Depends on what you mean by reusable elements. There are a lot of reusable elements, but I'm not familier with webparts.

-Export functionality (PDF)
Yes

-Email functionality
Yes

-Scheduling functionality
Yes, with QlikView Publisher.

-Better UI
Better than what? I like the UI just fine.

-Capabilities for mobile, i-pad reporting
Yes, but I think there's room for improvement here. The native iPad client I think doesn't take good advantage of the larger screen. You can publish in AJAX and pull it up in Safari on the iPad, but it doesn't work particularly well with the touch screen interface. They ARE actively working on it, though.

-Integration with .Net,MS Office,MS Sharepoint
Mmmm, not sure. You can export to and import from Excel. I know I've seen "sharepoint" mentioned many times on the forum. Not sure about .Net.

-Ease of use
For users, it's as easy as you make it for them as a developer. Generally pretty easy. For developers, I consider it fairly easy, though I think there are some definite areas for improvement.

-Response time, Memory consumption
Depends on how much data you have and how complicated you make your charts. Generally speaking, most of my real applications are near instantaneous or sub-second. Some of the more complicated ones are longer, with my absolute wost charts taking many seconds to finish calculating. For memory consumption, figure on about 10x compression of your raw data, but then add back in another 5-10% for every concurrent user of the data. Since analysis is done entirely in memory, you need that much RAM. You can't afford to swap to disk.

-Short build and deploy time
Yes

-Max. of Data Handling(2 TB or more)
I believe it was designed for gigabyte-scale databases. However, I am not aware of any technical limitations (other than available hardware) that would prevent you from using it on terabyte-scale databases. I think windows server maxes out at 2 TB, but in practice, you can run a lot of different applications on a lot of different servers to get around even that limitation. Should be doable, but I'd want to hear from people actually running that much data before making a commitment. Our shop probably has only 100 GB or less, so we don't count.

-Tech support(24 X 7)
I don't know tech support's hours. I've never called them. I email. But for most issues, I recommend the forum. It's very active and helpful.

-64 Bit OS support
Yes

Not applicable
Author

Thank you for your reply..