topic Re: Weekstart in set analysis in QlikView

Weekstart in set analysis

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

Hi, QlikView

I have a dataset that looks like that

Company	Date	Income	Other Income
Benz	02.01.2017	2.078.087	0
Benz	03.01.2017	3.560.614	5.000
Benz	04.01.2017	3.703.275	2.000
Benz	05.01.2017	3.524.276	1.000.000

I have one problem that I am trying to find solution. I have made a chart in the qlikview example.

That chart has two expressions sum (Income) and =sum({$<Date={'>=$(=WeekStart(Today(), 0))<=$(=Today())'}>}[Other Income])

I wanted to only get the other income for the current week.

My problem is that when I click on a date like 23.1.2017 my chart looks like below (chart 2). I know the set analysis for Other Income is the reason behind this. But can I use another set analysis that will show other income equals zero when I click on 23.1.2017 like chart 2.

Any ideas

Chart 1

Company	Date	Income	Other Income
Benz	23.1.2017	2.325.132	21.142
Benz	24.1.2017	0	32.563

Chart 2

Company	Date	Income	Other Income
Benz	23.1.2017	2.325.132	21.142

Regards Darri

Re: Weekstart in set analysis

vinieme12 — Tue, 24 Jan 2017 11:11:37 GMT

You can change the expression to below

=if(getselectedcount(Date)>0,sum([Other Income]),sum({$<Date={'>=$(=WeekStart(Today(), 0))<=$(=Today())'}>}[Other Income]))

Re: Weekstart in set analysis

suparnadas121 — Mon, 27 Dec 2021 09:47:18 GMT

Please use (") instead of (') in the above expression:

=if(getselectedcount(Date)>0,sum([Other Income]),sum({$<Date={">=$(=WeekStart(Today(), 0))<=$(=Today())"}>}[Other Income]))

Re: Weekstart in set analysis

markwood — Mon, 27 Dec 2021 12:00:23 GMT

You can try this expression to below

=if(getselectedcount(Date)>0,sum([Other Income]),sum({$<Date={'>=$(=WeekStart(Today(), 0))<=$(=Today())'}>}[Other Income])) Unlinked Apk