Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis issue

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

1 Solution

Accepted Solutions
sunny_talwar

I am unable to replicate the issue you are facing

Capture.PNG

View solution in original post

8 Replies
Anil_Babu_Samineni

Perhaps this

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

OR

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


OR


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


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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Chanty4u
MVP
MVP

addition to that

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

Not applicable
Author

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)

jonathandienst
Partner - Champion III
Partner - Champion III

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Mark_Little
Luminary
Luminary

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

sunny_talwar

I am unable to replicate the issue you are facing

Capture.PNG

Not applicable
Author

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!

sunny_talwar

Super