Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
is it possible to apply the same calculation condition to all the sheets of a Qw file setting it in one place instead of placing it in every chart?
(I'd like to avoid the calculation if no-selections are made, so that a computer freeze due to the large amount of data to be analyzed can't occurs).
Thank you so much.
N.
AFAIK it's not possible. To simplify such task you may use one or several variables and/or using a macro. Helpful could further be to create new objects not from the scratch else to copy an existing one - maybe a master-object for each relevant object-type from which it inherits the properties (not only for this condition else for many other settings - if needed is removing/changing a few one easier and faster than setting nearly everything new).
Further useful may be to implement a landing-page within the application without real application data and objects unless the main listbox for selections and with descriptions to the application content and their recommended usage - means the request to make selections. Maybe also with further links to the sheets and adding some actions with default-selections by opening them.
Another thought might go to the number of visible objects and how they are designed - especially tables which may return millions of rows or have a large number of columns and/or expressions should be avoided because nobody could really work with them in Qlik.
Before considering anything from above I suggest to check and optimize the datamodel because it's essential for the UI performance, means:
- Marcus
AFAIK it's not possible. To simplify such task you may use one or several variables and/or using a macro. Helpful could further be to create new objects not from the scratch else to copy an existing one - maybe a master-object for each relevant object-type from which it inherits the properties (not only for this condition else for many other settings - if needed is removing/changing a few one easier and faster than setting nearly everything new).
Further useful may be to implement a landing-page within the application without real application data and objects unless the main listbox for selections and with descriptions to the application content and their recommended usage - means the request to make selections. Maybe also with further links to the sheets and adding some actions with default-selections by opening them.
Another thought might go to the number of visible objects and how they are designed - especially tables which may return millions of rows or have a large number of columns and/or expressions should be avoided because nobody could really work with them in Qlik.
Before considering anything from above I suggest to check and optimize the datamodel because it's essential for the UI performance, means:
- Marcus
Hi Marcus,
Thank you for your very exhaustive answer!
Sorry if I didn't answer before, but I didn't receive the notification.
I'll follow your suggestions to reach the better result is possible.
See you soon.
Nick.