Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Move calculated dimension to script

Hi,

I have a question, i'm using calculated dimension to show the data. But it runs very slow when I implement the real data (large data). I have a suggestion to not using calculated dimension and use script to validate it.

But, i don't get the idea to implement it.

Anybody know how to make it ? I also attach my sample file here.

Really appreciate your help.

Thanks

7 Replies
Not applicable
Author

hi,

I think it might help u, and instead of using the calculated dimension u can use Person_name as the dimension.

untitled10.bmp

Not applicable
Author

Hi Harshitha,

Thanks for your suggestion, but unfortunately it doesn't work, because vPersonEligibility is a variable that i defined in the application. Maybe you can see the formula in the variable tab.

var.png

Do you have any idea ?

Hope you can help me and share the idea.

Thanks

Really appreciate your help.

gautik92
Specialist III
Specialist III

instead creating variable use that person eligibility also in the script.

Hope it helps

gautik92
Specialist III
Specialist III

Sry It will not work

gautik92
Specialist III
Specialist III

Can you send the excel sheet

Not applicable
Author

Hi Gowtham,

thanks for your response.

Yeah, i also confuse about it.

do you have another idea ?

Thanks

Not applicable
Author

This is the raw data (excel)