Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Formula within set analysis

Hi all,

i'm new to the Forum and very excited about QlikView.

Currently I have a Problem with using a formula within a set Analysis.

With disctinct data it Looks like this:

= num(
sum(
{<
Kalender.Datum = {"31.03.2017"}
>}
YE_WE_PosFAU.E_WE_LieferMenge)
, '###.##0')

This spits out the right result!

But if I ask like this:

= num(
sum(
{< Kalender.Datum = {$(max(YE_WE_PosFAU.PrüfDatum,3))}
>}
YE_WE_PosFAU.E_WE_LieferMenge)
, '###.##0')

it doesn't return the right numbers.

I have checked, and

=max(YE_WE_PosFAU.PrüfDatum,3))
is the 31.03.2017

Why is it, that the formula won't be calculated correctly?

Thank you in advance.

Kevin


1 Solution

Accepted Solutions
sunny_talwar

Try this

=Num(Sum({< Kalender.Datum = {"$(=Max(YE_WE_PosFAU.PrüfDatum,3))"}>} YE_WE_PosFAU.E_WE_LieferMenge), '###.##0')

View solution in original post

6 Replies
sunny_talwar

Try this

=Num(Sum({< Kalender.Datum = {"$(=Max(YE_WE_PosFAU.PrüfDatum,3))"}>} YE_WE_PosFAU.E_WE_LieferMenge), '###.##0')

Kushal_Chawda

try this

num(

sum(

{< Kalender.Datum = {"$(=max(YE_WE_PosFAU.PrüfDatum,3)))"}

>}

YE_WE_PosFAU.E_WE_LieferMenge)

, '###.##0')

sunny_talwar

Or this

=Num(Sum({< Kalender.Datum = {"$(=Date(Max(YE_WE_PosFAU.PrüfDatum,3), 'DD.MM.YYYY'))"}>} YE_WE_PosFAU.E_WE_LieferMenge), '###.##0')

swuehl
MVP
MVP

See also

Dollar-sign expansion using an expression ‒ Qlik Sense

Dates in Set Analysis

Also note that the dollar sign expansion is evaluated in global or total context, not per dimensional value.

Anonymous
Not applicable
Author

Thanks a lot, this worked!

Have a good day

Anonymous
Not applicable
Author

thank you!

It is the same solution as is the one by Mr Talwar. I guess yours has one too many brackets within the set Analysis. But if corrected, it worked out.

Thanks again!