Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Gauge chart and Data Reload problem

Hi All,

I have this query in SQL that returns the average duration of a data call made by subscribers.

select avg(duration) from
(
select (max(event_date)-min(event_date)) duration from usage_table
where subscriber_id is not null and session_id is not null
group by subscriber_id, session_id

)

My requirement is to represent the average duration in QlikView. I was thinking of a gauge chart indicating the average duration but couldn't figure out the implementation.All the fields (event_date, subscriber_id and session_id) are read from a flat table.

Please help me on this. Any alternative representation is also welcome.

Another problem with data reloading:

I have a QVW file that contains data from a large table. Reloading this table takes about 6-7 hours.

Now, I need to load from several smaller tables. So, if I add Load (and corresponding SQL) statements in Edit Script and reload, it reloads the large table too, which I want to avoid reloading. If I put an exit script statement, the QVW file loses the data from the large table.

So, how do I address this issue? Any best practices (creation of qvd file, etc) are welcome.

Regards

Amit

1 Reply
Not applicable

Gauge chart and Data Reload problem

Ok, found the solution to my second question. A partial reload with add in Load and Select does the job.

I still welcome any best practices.

Community Browser