Solved: Chart expression value in Text Object - Qlik Community

hamzabob1 · ‎2017-05-16

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

sunny_talwar · ‎2017-05-19

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')

View solution in original post

hamzabob1 · ‎2017-05-19

gwassenaar‌ bwisenosimenkg‌

Anil_Babu_Samineni · ‎2017-05-19

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anil_Babu_Samineni · ‎2017-05-19

Is this?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

hamzabob1 · ‎2017-05-19

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

Anil_Babu_Samineni · ‎2017-05-19

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?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

hamzabob1 · ‎2017-05-19

Dear Anil

I did not get ??

Regards

Hamza B

Anil_Babu_Samineni · ‎2017-05-19

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

hamzabob1 · ‎2017-05-19

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

Anil_Babu_Samineni · ‎2017-05-19

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful