topic Re: Comparing Greater Than Text Issue in QlikView

Comparing Greater Than Text Issue

calvin_wee — Mon, 12 Feb 2018 08:48:24 GMT

Hi All,

We need to implement a new Forecast Version Selection variable [vFcsVers] to show all future forecast version [FCST VERSION].

Before the change, we have this and it has been working fine.

num(

sum({<

[Fcst Version]=,

Sys_FcstVersion=,

[Reporting Month]={">=$(vMinMth)"},

[Fcst Month]={">=$(vMinMth_1)"}

Amount),'#0.0')

We added the comparison but it is not working as expected.

num(

sum({<

[Fcst Version]={"=[Fcst Version] follows '=$(vFcsVers)'"},

Sys_FcstVersion=,

[Reporting Month]={">=$(vMinMth)"},

[Fcst Month]={">=$(vMinMth_1)"}

Amount),'#0.0')

Output will be a cross table with all the Versions (After the selected version) showing on the left and Sum(Amount) as Expression.

Any advise is appreciated.

Thanks in advance & Best Regards

Re: Comparing Greater Than Text Issue

tresB — Mon, 12 Feb 2018 09:02:30 GMT

Are you planning to select multiple values? Have you considered getting them formatted in the variable accordingly? for single value try like:

[Fcst Version]={'$(vFcsVers)'},

Re: Comparing Greater Than Text Issue

marcus_sommer — Mon, 12 Feb 2018 12:38:24 GMT

I think I would try to use a numeric value for [Fcst Version]. It might include a period-value and a creator-id, type-id (best, real, worse) and also a version-number. Depending of your creating and/or storing of these forecast-data it might be possible to create this number with an autonumber().

- Marcus

Re: Comparing Greater Than Text Issue

calvin_wee — Mon, 12 Feb 2018 16:23:02 GMT

We need to have multiple values and this is not workable.

Thanks

Re: Comparing Greater Than Text Issue

calvin_wee — Mon, 12 Feb 2018 16:24:33 GMT

The alpha is needed as it is denoting the year in this case making comparing the number is not possible.

Thanks

Re: Comparing Greater Than Text Issue

calvin_wee — Mon, 12 Feb 2018 16:25:47 GMT

We managed to resolve using restrictions on Dimension. But we are still interested in getting the above in a formula via expression. Thanks and please keep suggestion coming.