Dimension as value in a set analysis expression

[#1]

Hello,

I've got the problem, that users would like to have values of dimensions in a set analysis expression, so that they can get a table like this:

Is there an opportunity to have an expression like this for the column "Sales NewCustomer":

Sum ({$<SalesDate={'>=NewCustomerFrom <=NewCustomerTill'} >} Sales)

Thanks!

Peggy

[nathanfurby]

This syntax should work:

sum({<Date={">=$(From) <=$(To)"}>} Value)

Of course there may be format issues - hard to test without the sample data.

[rbecher]

I think this should be quoted:

=Sum( {$<SalesDate={">='$(NewCustomerFrom)' <='$(NewCustomerTill)' "}>} Sales)

- Ralf

[#4]

Hi Chris,

thank you for your answers.

If I use your formular QlikView interprets it like this

I think its good to have an example QVW-file for this tricky problem, but I can't load it.

Regards

Peggy

[#5]

Thanks Ralf,

good idea, but in my example qvw it doesn't work...

Regards

Peggy

[#6]

May be it doesn't work with QV 9 Version?

[chris_johnson]

Hi,

Yes, I have found it will evaluate to blank values for the dates in the heading. I guess because there are multiple rows with different values in for the from and to dates it will not be able to show you. This is just the heading though, as long as you get the correct values it should be ok.

What do the values in your rows look like?

Regards,

Chris

[#8]

Hi Chris,

I have posted the example...

Can you have a look at it?

Thanks

[rbecher · Accepted solution]

This works on Version 10:

=Sum( if(SalesDate>=NewCustomerFrom AND SalesDate<=NewCustomerTill, Sales))

- Ralf

[#10]

Hallo Ralf,

danke! Das ist es!

Mal sehen ob ich das in meine komplexe Formel einbauen kann!

Viele Grüße

Peggy

[chris_johnson]

Hi,

I was actully just about to suggest that (honest), you're too quick for me Ralf!

Glad it got sorted in the end though.

Regards,

Chris