Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rzenere_avvale
Partner - Specialist II
Partner - Specialist II

How to calculate Classification based on cumulated percentage on script?

Hi everyone,

I'm trying to find a solution for my problem.

I have an app that works on desktop environment that gives a classification of a product based on a cumulated percentage.

This cumulated percentage is created on a table (that has fixed sort order, which is the descending order of a first measure we find in the table - that is also the measure on which we will calculate the percentage) in a hidden sheet; it is exported on qvd and then, when the app reloads, is loaded.

The percentage and the first measure we find in the table can be influenced by selections on year/month/day/quarter/... and also by the selection of an anagraphic detail of the product (there are SO many possibilities!).

Now I need to move this on a server environment and to make the application available on AccessPoint.

The environment has QV11.2 SR12 and a publisher, so exporting the table on the hidden sheet and giving the end user the possibility to reload the application is not really what I was looking for.

I've tried to calculate this classification dynamically on the frontend, but I'm not able to handle the sort order. The sort is based on the first measure on the table and not a dimension (so no, the sort option that we can find with the aggr function in QV12 is not the solution).

So, not being able to calculate this on the frontend, I thought that maybe calculating this on a cross table in the model would have been the solution.

Calculating the first measure (numerator of the percentage) was not a big problem, but I'm worrying about how to calculate the percentage: there are really many options that can influence the denominator, and I can't think of any way to handle them.

Do you have any hint about how to move this on a script level and how to handle the percentage?

Thanks to anyone that will help me

1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Dear Riccardo,

It would be great if you can show us what you have done till now and show us what is your problem.

If possible please post the application which has the script and sample data.

Regards,

Kashik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!