topic One dimention to select certain variable in expression in QlikView

One dimention to select certain variable in expression

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

Hello Team,

I am trying to bring in one dimention (Related Collateral =Y) to my query. However, every time i am trying it getting null value.

How can I incorpotate (Related Collateral =Y) to my expression, please help.

Many Thanks in advance.

Regards

Mohi

vinieme12 — Fri, 24 Mar 2017 10:54:11 GMT

Using SetAnalysis

count({<Related Collateral ={'Y'} >} [YourFieldName] )

mohiahmed — Fri, 24 Mar 2017 11:02:16 GMT

Thanks Pujari, however when I add that to second part of my expression it coming up with an error

Please help

count

({<[Related Collateral] ={'Y'} >}[New Unsecured DD SLA])/count({<[Related Collateral] ={'Y'}>}(total<[Processing Area]>[New Unsecured DD SLA]))

vinieme12 — Fri, 24 Mar 2017 11:05:01 GMT

adamdavi3s — Fri, 24 Mar 2017 13:34:07 GMT

Looks like it might just be an extra bracket set in there to me

count({<[Related Collateral] ={'Y'} >}[New Unsecured DD SLA])

count({<[Related Collateral] ={'Y'}>}total<[Processing Area]>[New Unsecured DD SLA])

vinieme12 — Fri, 24 Mar 2017 13:40:15 GMT

count({<[Related Collateral] ={'Y'} >}[New Unsecured DD SLA])

count(TOTAL <[Processing Area]> {<[Related Collateral] ={'Y'}>} [New Unsecured DD SLA])

marcus_sommer — Fri, 24 Mar 2017 14:18:17 GMT

Try this:

count({<[Related Collateral] ={'Y'} >} [New Unsecured DD SLA]) /

count({<[Related Collateral] ={'Y'}>} total<[Processing Area]> [New Unsecured DD SLA])

- Marcus

Anil_Babu_Samineni — Sat, 25 Mar 2017 16:34:06 GMT

Remove parenthesis of before Total and then remove one more of end part.

adamdavi3s — Mon, 27 Mar 2017 06:05:47 GMT

well done for copying at least two of the above answers