Group by not working in Value list

[paulwalker]

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!

[paulwalker]

@tresesco  and All, Any suggestions would be appreciated

[Chanty4u]

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)))

[paulwalker]

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

[paulwalker]

Experts, can you please have a look once.

[vinieme12]

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)))))

[tresesco]

@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.