topic Re: How to show calculated field in UI level in QlikView

How to show calculated field in UI level

madhubabum — Tue, 28 Jul 2015 08:27:04 GMT

Hi all

Here I am attaching the Sample Application:

Problem : If i am using the calculation in Script level "Getting Some Profit Center's " Information only in UI level.

But , If i'm using the same calculation in UI level "Getting All Profit Centers" Information.

I want to Use calculation in Script level & I want to show " All Profit Center's information in UI level".

How we can Achieve this one ?

vardhancse — Tue, 28 Jul 2015 08:48:45 GMT

Was not clear,

are you trying to see the data for the calculated filed created in script level.?

madhubabum — Tue, 28 Jul 2015 09:10:38 GMT

Hi Sasi v Kandragula

Thanks for your reply

I want to show in UI level

madhubabum — Tue, 28 Jul 2015 09:18:52 GMT

Avg(if(%ORDER_DATE_KEY >$(vEndDate),WorkOrderLaborHours)) as Last_12_Months_Avg_Labour_Hours

madhubabum — Tue, 28 Jul 2015 09:19:26 GMT

Avg(if(%ORDER_DATE_KEY >$(vEndDate),WorkOrderLaborHours)) as Last_12_Months_Avg_Labour_Hours

jagan — Tue, 28 Jul 2015 09:37:10 GMT

Hi,

Try like this

Avg(if([%ORDER_DATE_KEY] >'$(vEndDate)',WorkOrderLaborHours)) as Last_12_Months_Avg_Labour_Hours

Regards,

Jagan.