topic Re: Set Analysis in Text Object in QlikView

Set Analysis in Text Object

Anonymous — Fri, 05 Apr 2013 23:45:46 GMT

Hello! I have a text object with a formula =money((sum({<Aspect={'Actuals'}>}[Total Value])/(((today()-min(DateKey))+1)*7)) . In this formula. I only want to get the Total Value of Actuals /no of days ... This one works if I select the Actuals in the Aspect box. However, it recalculates when I select other aspects (not actuals) for which I don't understand how its being computed where it shows weird figures. Thus, is there any way to freeze the value at the actuals aspect or to disregard any selections under Aspect object?

Pls. help...

Re: Set Analysis in Text Object

Sokkorn — Sat, 06 Apr 2013 01:32:03 GMT

Try =money((sum({1<Aspect={'Actuals'}>}[Total Value])/(((today()-min(DateKey))+1)*7))

Regards,

Sokkorn

Re: Set Analysis in Text Object

Gysbert_Wassenaar — Sat, 06 Apr 2013 08:30:35 GMT

Maybe this is what you want:

=money((sum({<Aspect={'Actuals'}>}[Total Value])/(((today()-min({<Aspect={'Actuals'}>}DateKey))+1)*7))

Re: Set Analysis in Text Object

Anonymous — Tue, 09 Apr 2013 00:00:19 GMT

Thank you for saving me twice, Gysbert...This is what I actually need ! ..

Re: Set Analysis in Text Object

Anonymous — Fri, 19 Apr 2013 21:31:26 GMT

Gysbert,

Can you explain to me why you add a set analyisis on this statement (((today()-min({<Aspect={'Actuals'}>}DateKey))+1)*7)) ? I really don't quite get it why you used the Aspect={'Actuals'}....

Actually, I have another text object with almost the same concept . I used this statement but it didn't work.