Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
juan_patrick
Creator
Creator

Getselectedcount and Set analysis

Hi!

I have the expression:

IF(GetSelectedCount(date)=0,

     Sum({<consecutive= { $(=MAX(consecutive)-1)} >} field1),

     (Sum(field1))

)

I have dates, and the rule is:

if there is no one selected, sum field1 by the max date

if there one or more than one date selected, sum field1 by that dates.

The code ots ok with the rule, but, its slos, and i think if I can do it all in set analysis will be faster than now.

Thanks!!

1 Reply
prat1507
Specialist
Specialist

Sum({<consecutive= { '$(=IF(GetSelectedCount(date)=0,MAX(consecutive)-1,'*')'} >} field1)