topic Re: Qlik Sense Store/Export Chart as qvd in App Development

Qlik Sense Store/Export Chart as qvd

robbybalboa — Fri, 15 Nov 2024 23:25:31 GMT

Dear User group,

in QlikView we export table charts into qvd.
To do it via skript (join + group by + store) is very hard because of the huge amount of data.

In Qlik Sense I need this function as well, but cannot find a possibility to do that.

Question: Is this possible or not? If yes, how to do?

THANK you for your feedback
Robert

Re: Qlik Sense Store/Export Chart as qvd

Patricia_Silva — Mon, 13 Dec 2021 11:16:01 GMT

Hello @robbybalboa, how were you doing the conversion of charts from qlik view to QVD if not using the script function?

Re: Qlik Sense Store/Export Chart as qvd

robbybalboa — Mon, 13 Dec 2021 11:22:54 GMT

Hello Patricia,

I have round about 1 Billion rows with an amount =cost (per year).
This I have to combine with ~ 30.000 item information and 25.000 customer rows.
If I join it and afterwards use group by I get performance problems.

To avoid this I read in the three tables in one Qlik App, create a Chart and make my different aggregations I need.
+ then I store it as an qvd.

As I need this qvd only every three month it is not necessary to update via QEMC.

I hope this helps you do understand the issue.

With regards
Robert