Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to set expression with more "Dimensions"

Hello,

i have this expression:

sum({<[Mjesto troška]={'SP0101'}>} NETO)-sum({<[Mjesto troška]={'SP0101'}>} NBVR)

this expression calculates the Profit where Mjesto troška is "SP0101"

Now, i have more Mjesto troška that i would like to include. They all start with SP0.. and then 101,102,103, 201,202,203.. and so on...

This would be unnecessary code to integrate all the Mjesto troška for itself...

Is there a formula like "begins with(excel)" sum the Profit where Mjesto troška begins with "SP0.."?

Thank you in advance for your help

1 Solution

Accepted Solutions
maxgro
Not applicable

Re: How to set expression with more "Dimensions"


try this, double quote, *

sum({<[Mjesto troška]={"SP0*"}>} NETO)

3 Replies
maxgro
Not applicable

Re: How to set expression with more "Dimensions"


try this, double quote, *

sum({<[Mjesto troška]={"SP0*"}>} NETO)

Not applicable

Re: How to set expression with more "Dimensions"

Works. thank you

maxgro
Not applicable

Re: How to set expression with more "Dimensions"

you can find previous answer and a lot of others in the very good doc of Aunez Fabrice, here

Set Analysis: syntaxes, examples