topic Re: Chart expression value in Text Object in QlikView

Chart expression value in Text Object

hamzabob1 — Tue, 16 May 2017 10:11:36 GMT

Hello friends

I have a expression in chart for service tax which I need to showcase in a text object.

I am able to achieve the same for INR amount,

Kindly find the sample application attached.

Thanks in advance for your help!!

Regards

Hamza B

Re: Chart expression value in Text Object

hamzabob1 — Fri, 19 May 2017 04:40:20 GMT

gwassenaar‌ bwisenosimenkg‌

Re: Chart expression value in Text Object

Anil_Babu_Samineni — Fri, 19 May 2017 05:08:03 GMT

Can you tell us the context, Where we need to look and which value you are expecting to see

Re: Chart expression value in Text Object

Anil_Babu_Samineni — Fri, 19 May 2017 05:10:08 GMT

Is this?

Re: Chart expression value in Text Object

hamzabob1 — Fri, 19 May 2017 05:14:10 GMT

Dear Anil

Thanks for your reply.

Yes you are correct , we need to get the value for Service tax as highlighted in a text object.

Currently it is in report. While we did , as available there the values are not matching.

Regards

Hamza B

Re: Chart expression value in Text Object

Anil_Babu_Samineni — Fri, 19 May 2017 06:25:42 GMT

When you look Match, It's difficult to tell because we are not seeing and testing any thing here.

And, You are expecting matching values? Could be wrong expression. Can you share the business, May be?

Re: Chart expression value in Text Object

hamzabob1 — Fri, 19 May 2017 09:41:20 GMT

Dear Anil

I did not get ??

Regards

Hamza B

Re: Chart expression value in Text Object

Anil_Babu_Samineni — Fri, 19 May 2017 09:55:23 GMT

You are cross checking with something else, Right?

In Front-end how can i help you? Can you show the case where i have to work again

Re: Chart expression value in Text Object

hamzabob1 — Fri, 19 May 2017 10:07:51 GMT

Dear Anil

The Service tax amount field which u highlighted in Yellow , needs to be displayed in a text object.

Is there anything else which can be provided to you for clarification?

Thanks & Regards

Hamza b

Re: Chart expression value in Text Object

Anil_Babu_Samineni — Fri, 19 May 2017 10:22:11 GMT

Haha, May be i am in different mood

Try this for Service Tax

=Num(sum(Aggr(sum(DISTINCT CALCUL),S_BF_NO,S_TRANSACTION_ID)),'#,##0.00')

And this for INR Amount

=Num(sum(Aggr(sum(DISTINCT CALCUL_AMOUNT),S_BF_NO,S_TRANSACTION_ID)),'#,##0.00')

If still on doubt, I may not following you right manner

Re: Chart expression value in Text Object

hamzabob1 — Fri, 19 May 2017 11:30:28 GMT

Dear Anil,

I think your not getting wat i am trying to say you...

So let it be...

Regards,

Hamza

Re: Chart expression value in Text Object

Anil_Babu_Samineni — Fri, 19 May 2017 11:34:06 GMT

May be stalwar1‌

Re: Chart expression value in Text Object

sunny_talwar — Fri, 19 May 2017 11:46:13 GMT

Not sure but may be this

=Num(Sum(Aggr(if(

if(sum({<S_TAX_TYPE={'*'}>} S_TAX_AMOUNT)*sum(DISTINCT S_EX_RATE)=0,

sum({<S_SERVICE_DESCRIPTION={'*'}>} S_TAX_AMOUNT)*sum(DISTINCT S_EX_RATE),

sum({<S_TAX_TYPE={'*'}>} S_TAX_AMOUNT)*sum(DISTINCT S_EX_RATE))=0,

sum({<S_SERVICE_TYPE={'*'}>} S_TAX_AMOUNT)*sum(DISTINCT S_EX_RATE),

if(sum({<S_TAX_TYPE={'*'}>} S_TAX_AMOUNT)*sum(DISTINCT S_EX_RATE)=0,

sum({<S_SERVICE_DESCRIPTION={'*'}>} S_TAX_AMOUNT)*sum(DISTINCT S_EX_RATE),

sum({<S_TAX_TYPE={'*'}>} S_TAX_AMOUNT)*sum(DISTINCT S_EX_RATE))), S_ZONE1, S_BRANCH_NAME, S_BOOKING_LEAD, S_AGENT_NAME, S_EMP_ID, S_REGION_CODE, S_LT_PROD_CODE, S_BF_NO, S_TRANSACTION_ID, DATE, S_CURRENCY_CODE, S_VALUE, S_DEPARTURE_DATE, S_END_TOUR_DATE, S_AMOUNT, S_EX_RATE)), '#,##0')

Re: Chart expression value in Text Object

hamzabob1 — Fri, 19 May 2017 12:08:16 GMT

Dear Sunny,

Thank you so much really appreciate your work..

thanks again,

Hamza