
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
=Num(Sum({< Kalender.Datum = {"$(=Max(YE_WE_PosFAU.PrüfDatum,3))"}>} YE_WE_PosFAU.E_WE_LieferMenge), '###.##0')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
=Num(Sum({< Kalender.Datum = {"$(=Max(YE_WE_PosFAU.PrüfDatum,3))"}>} YE_WE_PosFAU.E_WE_LieferMenge), '###.##0')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
num(
sum(
{< Kalender.Datum = {"$(=max(YE_WE_PosFAU.PrüfDatum,3)))"}
>}
YE_WE_PosFAU.E_WE_LieferMenge)
, '###.##0')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Or this
=Num(Sum({< Kalender.Datum = {"$(=Date(Max(YE_WE_PosFAU.PrüfDatum,3), 'DD.MM.YYYY'))"}>} YE_WE_PosFAU.E_WE_LieferMenge), '###.##0')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See also
Dollar-sign expansion using an expression ‒ Qlik Sense
Also note that the dollar sign expansion is evaluated in global or total context, not per dimensional value.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a lot, this worked!
Have a good day

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
