Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Using Aggr + If and Set Analysis

Hello,

I have the following expression in straight table:

count( {< [LF tipo budget] = >} DISTINCT

aggr( if(

sum( {< _FATTURATOFlag = {"S"}, [LF tipo budget] =, _FATTURATO_YTD_APFlag = {"S"} >} [Importo netto riga] )>0,

[%Codice cliente], null()),

$(vDimGrpResoGroup), [%Codice cliente] ) )

It works well, but I need the expression to be not affected from the selection on field named "LF tipo budget".

Can anyone help me to achieve it ?

Thanks in advance for your time.

Best Regards

Andrea

2 Replies
Highlighted
Contributor III
Contributor III

Did you solve this?

If so, how?

Highlighted
Partner
Partner

I solved separating the table with "LF tipo budget" from the cloud.