topic Re: Problem building an expression in QlikView

Problem building an expression

Thu, 11 Sep 2014 09:03:18 GMT

Hello guys!

I have a problem building an expression:

=sum({$<Year={$(=FieldValue('Year', $(=Valueloop(1,100))))}>}[Total N $(=maxstring(Unit))])

This expression don't work because it don't execute the function Valueloop.

All i want to do in this expression is to dynamically do the sum for each year that i've got.

Can someone help me please?

Thanks,

Regards,

Loïc

rubenmarin — Thu, 11 Sep 2014 09:12:46 GMT

If you want all years you can remove year selection in set analysis:

=sum({$<Year>}[Total N $(=maxstring(Unit))])

Thu, 11 Sep 2014 09:19:18 GMT

Hello,

Thanks man, but in your expression you don't take care about the selection of the year.

For example, i have 3 years: 2012, 2013 and 2014.

I want 3 columns with de sum ==> this is ok with your expression

If the user select 2012 and 2014 i want the column '2013' to remove ==> this is not ok

rubenmarin — Thu, 11 Sep 2014 09:24:14 GMT

Hi loic,

Maybe i don't undertad the full requirements, both examples in your last post is the normal behaviour of qlikview, don't need of set analysis:

=sum([Total N $(=maxstring(Unit))])

I'm missing something? can you upload a sample and what you expect?

Thu, 11 Sep 2014 09:29:07 GMT

Yeah you're right man, i'm so bad today. ^^

I think i should better go sleep...

Thanks again