topic Re: multiple Set analysis in QlikView

multiple Set analysis

rolandg1881 — Sat, 31 Oct 2020 23:01:11 GMT

Hi!

Hope you are all fine!

I've one question please.

I have the following set analysis:

sum({<[Value] = {'Workdays'}>}[Days])

the is the sum of Days which where Workdays other Values are for example 'Holidays'.

What i need is this: for example i chose the Month from January to July in the Report

BUT in this field i only want to see the 'Workdays' from July (max(month).

Is there any solution where i can say in set analysis value for max(month) ?

Thank you!

Roland

Vegar — Sat, 31 Oct 2020 23:29:59 GMT

This expression should do what you're asking for.

sum({<[Value] = {'Workdays'}, [Month] ={'$(=MaxString ([Month] )) ' } >}[Days])

rolandg1881 — Sat, 31 Oct 2020 23:56:23 GMT

Hi!

Thank you for your help!

Looks good but wont work. 😉

sum({<[Buchungsart] = {'Zeitausgleich'}, [AMS_Monat] ={'$(=MaxString ([AMS_Monat] )) ' } >}[Nettozeit])

if i take this formula:

Sum({<[Buchungsart]={'Zeitausgleich'}>}[Nettozeit])

and chose only July it works but i need to chose March to July for other formulas in the report

AMS_Monat arte the months i chose in the picture but the value for [Nettozeit] and July shows 0 for very row with this formula. 😞

rolandg1881 — Sun, 01 Nov 2020 10:04:48 GMT

It works only the ' was wrong.

sum({<[Value] = {'Workdays'}, [Month] ={$(=MaxString ([Month] )) } >}[Days])

Thaaaaank you!