topic Re: Move calculated dimension to script in QlikView

Move calculated dimension to script

Mon, 07 Sep 2015 02:34:49 GMT

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

Re: Move calculated dimension to script

Mon, 07 Sep 2015 05:21:40 GMT

hi,

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

Re: Move calculated dimension to script

Mon, 07 Sep 2015 05:27:17 GMT

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.

Do you have any idea ?

Hope you can help me and share the idea.

Thanks

Really appreciate your help.

Re: Move calculated dimension to script

gautik92 — Mon, 07 Sep 2015 05:32:37 GMT

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

Hope it helps

Re: Move calculated dimension to script

gautik92 — Mon, 07 Sep 2015 05:34:15 GMT

Sry It will not work

Re: Move calculated dimension to script

gautik92 — Mon, 07 Sep 2015 05:35:02 GMT

Can you send the excel sheet

Re: Move calculated dimension to script

Mon, 07 Sep 2015 05:35:30 GMT

Hi Gowtham,

thanks for your response.

Yeah, i also confuse about it.

do you have another idea ?

Thanks

Re: Move calculated dimension to script

Mon, 07 Sep 2015 05:36:10 GMT

This is the raw data (excel)