Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
calvin_wee
Creator
Creator

Comparing Greater Than Text Issue

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

5 Replies
tresesco
MVP
MVP

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)'},

marcus_sommer

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

calvin_wee
Creator
Creator
Author

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

Thanks

calvin_wee
Creator
Creator
Author

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

Thanks

calvin_wee
Creator
Creator
Author

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.