topic Re: Set analysis issue in QlikView

Set analysis issue

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I need to find away to get around these less than signs (<=30 and <=60) in my set analysis, because QV should not see them as a statement but as text.

Can someone help me?

My set analysis:

sum({$<VervallenSegmStatus -= {'<=30', '<=60'}>} _Saldo)

Thanks for your help!

Jasper

Re: Set analysis issue

Anil_Babu_Samineni — Tue, 02 Aug 2016 08:54:55 GMT

Perhaps this

sum({$<VervallenSegmStatus -= {"<=30 <=60"}>} _Saldo)

sum({$<VervallenSegmStatus -= {<=30 <=60}>} _Saldo)

If you don't want to show in b/w of 30 and 60 you should write like below

sum({$<VervallenSegmStatus -= {">=30 <=60"}>} _Saldo)

Re: Set analysis issue

Chanty4u — Tue, 02 Aug 2016 09:04:00 GMT

addition to that

sum({$<VervallenSegmStatus -= {'<=30' and ' <=60'}>} _Saldo)

Re: Set analysis issue

Tue, 02 Aug 2016 09:11:15 GMT

I have made a new example to show my problem in another way.

This set analysis works but it does not show '<720', these are all labels so the less than sign should not be seen as a statement but as a text. The other labels are shown, only '<720' not!

=sum({$<VervallenSegmStatus = {'61<=90', '91<=180', '181<=270', '271<=360', '361<=720', '<720'}>} TOTAL <Klant> _Saldo)

Re: Set analysis issue

jonathandienst — Tue, 02 Aug 2016 09:16:44 GMT

The <=30 is already covered by the <=60, so can be discarded.

sum({$<VervallenSegmStatus -= {"<=60"}>} _Saldo)

If you mean >=30, then

sum({$<VervallenSegmStatus -= {">=30 <=60"}>} _Saldo)

Re: Set analysis issue

Mark_Little — Tue, 02 Aug 2016 09:28:13 GMT

Hi,

Could be something you could do in script.

Something like

Load,

ID,

IF(Sum(VervallenSegmStatus) >= 30 and Sum(VervallenSegmStatus) <= 60, 1,0) AS Flag

Resident Table

groupby ID;

Then the set analysis Sum({<Flag=1>}_Saldo)

Mark

Re: Set analysis issue

sunny_talwar — Tue, 02 Aug 2016 10:38:40 GMT

I am unable to replicate the issue you are facing

Re: Set analysis issue

Tue, 02 Aug 2016 11:02:46 GMT

Thanks to looking at your example, i noticed that the set analysis worked but the problem was due to a bad dimension.

Thanks for your help!

Re: Set analysis issue

sunny_talwar — Tue, 02 Aug 2016 11:51:17 GMT

Super