topic Change in Expression in QlikView

Change in Expression

Anonymous — Sun, 23 Apr 2017 16:55:16 GMT

Dear Friends

We have a text object having large expression (inefficient performance) where in amount is being calculated along with different service tax for different periods. Hence the expression has become long.

We intend to remove the service tax calculations for previous years and keep only for 2017 .

(By removing getfieldselections function for April, June 2016 etc.)

However I am getting confused to implement the same by modifying the expression.

The attachment contains the expression.

Thanks & Regards

Chintan Gala

Message was edited by: Chintan Gala To clear the confusion, Have added another text object which shows what changes are intended.

Re: Change in Expression

sunny_talwar — Mon, 24 Apr 2017 09:12:05 GMT

How do we find service tax within your formula? is it part of set analysis or do you have a field which says Service Tax Amount?

Re: Change in Expression

Anonymous — Mon, 24 Apr 2017 09:26:43 GMT

Hello Sunny

There is no seperate field such as Service Tax. Hence the amount is multiplied by 100/109 to get 9% as the service tax amount.

As the expression is heavy- the text objects do not appear on browser, we are thinking to remove the different service tax calculations for different periods and instead just calculate present 9% rate.

Thanks & Regards

Chintan.

Re: Change in Expression

sunny_talwar — Mon, 24 Apr 2017 09:28:50 GMT

So what exactly are you trying to remove? I am not sure I understand what is getting removed from the expression? Anywhere where the date if 2016 or less?

Re: Change in Expression

Anonymous — Mon, 24 Apr 2017 09:54:07 GMT

Yes exactly. Only calculate service tax as 9% irrespective of the period selected.

(Remove previous different calculations for different periods), which would make the expression lighter.

Re: Change in Expression

Anonymous — Thu, 27 Apr 2017 07:04:03 GMT

Dear Sunny

I have added a text object 'New Expression' to clear the confusion regarding what we intend to make.

Regards

Chintan

Re: Change in Expression

sunny_talwar — Thu, 27 Apr 2017 09:22:54 GMT

So are you looking to get rid of the commented part and still the expression should work? Is that the goal?

Re: Change in Expression

Anonymous — Thu, 27 Apr 2017 09:27:12 GMT

Yes, exacty!

Re: Change in Expression

sunny_talwar — Thu, 27 Apr 2017 16:45:01 GMT

Check the attached

Re: Change in Expression

Anonymous — Sun, 30 Apr 2017 06:33:51 GMT

Dear Sunny

Thanks for your reply.

The result is coming different. (338 versus 331).

I am trying to comment more of the code with same conditions till the bottom and check again. I will let u know if I need further help.

Regards

Chintan

Re: Change in Expression

Anonymous — Tue, 02 May 2017 10:18:03 GMT

Dear Sunny

PFA

I am trying to get the expression as named Required. But with errors.

In that I need to comment all the conditions except this year >22-Jan-2017...