Assist with Set Analysis and Dual Variable

QFanatic — Mon, 29 Mar 2021 10:08:57 GMT

Hi there

Please find attached.

The model is self explanatory. I'm trying to do a Set Analysis in the Blue Text box for the Current Fin Year (20/21) and it should return 5.17, but it doesnt. I'm almost sure it is the syntax, because FY is Dual.

1. From research I have done I got - the set comparison always compares against the text value of a dual. So I created a variable called vFY.

2. The result that I am getting is not correct. what is wrong with my Set Analysis?

Much appreciated.

Thank you.

Re: Assist with Set Analysis and Dual Variable

Dalton_Ruer — Wed, 05 May 2021 20:10:14 GMT

Try setting your FY to something else text wise. When I simply $(vFY) it yields the math from 20/21.

topic Re: Assist with Set Analysis and Dual Variable in QlikView

Assist with Set Analysis and Dual Variable

Re: Assist with Set Analysis and Dual Variable