topic Re: Sum two periods in QlikView

Sum two periods

sergio0592 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have data with orders nb associated with two fields :

-period (Day / Night)

-week (Week / Week-end)

In my chart i display orders nb for Day Week (monday to friday and 08:00 to 18:00) and Night / Week-End (Saturday and sunday or night monday to friday).

It works but i have to sum Orders WE with Orders NW. And i wonder if there a way to simplify this with just one Set Analysis line?

Regards

Re: Sum two periods

sunny_talwar — Mon, 10 Oct 2016 22:34:09 GMT

May be like this:

=If($(vValue_list)='Day&Week',sum({$<Period={"D"},Week={"W"}>} [Orders nb]),

Sum({$<Period={"N"}, Week={"W"}>+$<Week={"WE"}>} [Orders nb]))

Re: Sum two periods

sergio0592 — Mon, 10 Oct 2016 22:54:14 GMT

I made sum of Set analysis and from now thanks to you i'll make sum inside Set analysis!