topic Checking an expression against a Substring Value in QlikView

Checking an expression against a Substring Value

sunil2288 — Thu, 01 Jul 2010 11:13:44 GMT

Hi Everyone,

After a long period having some problem while developing finance analysis.

Actually i have a model where there is a field named "HFM_Code"which is having values like 'P0300000-Sales expenditure' which are string value . i need to calculate the sum(amount) incurred against the HFM_Code='P0300000' only.

How to resolve this ....

Reply appreciated

Thanks

Suneel

Checking an expression against a Substring Value

Or — Thu, 01 Jul 2010 11:18:12 GMT

Assuming the code and text description are always separated by a dash, you should be able to use the following:

left(HFM_Code,Index(HFM_Code,'-')-1)

If this isn't what you meant, please post sample data / expected result or a sample QVW.

Checking an expression against a Substring Value

johnw — Thu, 01 Jul 2010 22:10:20 GMT

If I understood the question, in the script:

subfield(HFM_Code,'-',1) as HFM_Code_Group

Then where you want to do the sum:

sum({<HFM_Code_Group={'P0300000'}>} amount)

Checking an expression against a Substring Value

sunil2288 — Fri, 02 Jul 2010 06:14:41 GMT

Wow John.....

You understood my problem well and solved it quite comfortably.

Thank you very much