topic Re: How to get value from parameter base on condition ? in QlikView

How to get value from parameter base on condition ?

danipudianto — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

How to get Value PLANNED_DT / JAM KERJA in MIN Column ?

I have try make query : sum({<DOWNTIME={'PLANNED_DT'}>MINUTES ) / sum({<DOWNTIME={'JAM KERJA'}>MINUTES)

but the result in PLANNED_DT % = 0

Please get me Solution

Thanks

Anil_Babu_Samineni — Mon, 07 Aug 2017 09:53:29 GMT

Expression wrong in your thread, try this

sum({<DOWNTIME={'PLANNED_DT'}>} MINUTES)/ sum({<DOWNTIME={'JAM KERJA'}>}MINUTES)

Kushal_Chawda — Mon, 07 Aug 2017 10:08:47 GMT

At first glance, looks like a syntax error

sum({<DOWNTIME={'PLANNED_DT'}>} MINUTES ) / sum({<DOWNTIME={'JAM KERJA'}>}MINUTES)

danipudianto — Mon, 07 Aug 2017 10:12:53 GMT

Sorry,

but no difference between your query and me.

and the result still zero

Thanks

Anil_Babu_Samineni — Mon, 07 Aug 2017 10:15:17 GMT

Two to split

sum({<DOWNTIME={'PLANNED_DT'}>} MINUTES)

danipudianto — Mon, 07 Aug 2017 11:36:48 GMT

Hi Anil,

Sorry I am still confuse,

I want the value in PLANNED_DT % = PLANNED_DT / JAM KERJA

and my script is

=if(DOWNTIME='PLANNED DT %',sum({<DOWNTIME={'PLANNED_DT'}>} MINUTES) / sum({<DOWNTIME={'JAM KERJA'},DOWNTIME>}MINUTES),

sum(MINUTES))

but the result in PLANNED_DT % = 0

It's wrong in my script ?

Thanks

Anil_Babu_Samineni — Mon, 07 Aug 2017 11:46:25 GMT

Are you trying this in Script? Try same expression in UI