topic Re: Group by not working in Value list in App Development

Group by not working in Value list

paulwalker — Fri, 28 Apr 2023 05:21:21 GMT

Hi Community,

I am facing problem with AGGR in value list size and expression.

First chart I am manually passing values based on ID and second chart based on ID field is working fine (AGGR works fine in second chart as I have dimension)

In my scenario I need to calculate and sum each ID level so that the value is 1.50

This 1.50 value should be shown in the first chart in the highlighted cell, I am trying to apply the same expression in the first chart but it is not working.

Expression: In the first chart my expression is as follows, that's why it's not working

IF(LIST=1, Exp1+Exp2,
IF(LIST=2, Exp1,
IF(LIST=3, Exp2)))

PFA, (I have applied selection in attached file)

Thanks in Advance!

Re: Group by not working in Value list

paulwalker — Thu, 27 Apr 2023 16:04:04 GMT

@tresB and All, Any suggestions would be appreciated

Re: Group by not working in Value list

Chanty4u — Thu, 27 Apr 2023 17:36:18 GMT

Try this

IF(SUM(Exp1 + Exp2) >= 1.5, 1.5, SUM(Exp1 + Exp2))

To use this expression in your first chart, you can replace your current expression with the new one

IF(LIST=1, IF(SUM(Exp1 + Exp2) >= 1.5, 1.5, SUM(Exp1 + Exp2)),

IF(LIST=2, Exp1,

IF(LIST=3, Exp2)))

Re: Group by not working in Value list

paulwalker — Thu, 27 Apr 2023 17:46:47 GMT

based on selection that should change, that's just an example

Re: Group by not working in Value list

paulwalker — Fri, 28 Apr 2023 00:22:40 GMT

Experts, can you please have a look once.

Re: Group by not working in Value list

vinieme12 — Fri, 28 Apr 2023 03:37:57 GMT

Add the TOTAL keyword, refer below

=IF(LIST=1, Count(DISTINCT position_number)+Sum(AGGR(1-(1/COUNT(DIStINct SubField([Covered. ES Name],','))),unix_id)),
IF(LIST=2, Count(DISTINCT position_number),
IF(LIST=3, Sum(TOTAL AGGR(1-(1/COUNT(DIStINct SubField([Covered. ES Name],','))),unix_id)))))

Re: Group by not working in Value list

tresB — Fri, 28 Apr 2023 05:07:45 GMT

@paulwalker , I can't open your qvw file anymore (#qlik - MVP license has expired). However, if I take from your subject line - you are using valuelist() in dimension; if that is the case - let me tell you that qlik synthetic dimension (created by valuelist(), valueloop() ) - doesn't respond to selection. What you can instead try with is creating a island dimension in the script and use that as the dimension.