Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Qlikview- Performance improvement 35M+ records

I am stuck on a really clumsy issue of performance and latency in a Qlikview Dashboard with 35M records. I wanted to know the ways to actually improve my model/ front end expression to improve speed. To get a perspective. I have weather data for each day for 8 years with respective States of 20+ countries. Tables- State_code Area polygon(from KML file) Date Stat (Min/Max/Avg) Weather_field- Temperature/Wind Direction/ Pressure Value (numeric)

So user has the ability to select any date range in between the 8 years. Filters from Stat, Country, Weather_field etc. I used a nested if loop to get all the combinations possible like.         MyAccountAccess Mobile App

Stats=max, weather_field= temperature, date range( start and end date) calculate max(value)

How to prove it. Please help

Labels (1)
  • Other

0 Replies