Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help in set_analysis syntax

Hi guys,

I have a set_analysis formula:

=Num(Count(Distinct {$<QtaGiacente={"<>0"}, AnnoUltimoMovimento={"<2005"}>} CodiceArticolo),'#.##0')

and I like to replace the value 2005 with the variable AnnoInizioObsolescenza

Should someone help me with the properly syntacs?

Thanks a lot.

N.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

If AnnoInizioObsolescenza is a variable and not a field then you do it like this:


=Num(Count(Distinct {$<QtaGiacente={"<>0"}, AnnoUltimoMovimento={"<$(AnnoInizioObsolescenza)"}>} CodiceArticolo),'#.##0')


But if AnnoInizioObsolescenza is a field then all bets are off. See this document: set_analysis_intra-record.qvw


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

If AnnoInizioObsolescenza is a variable and not a field then you do it like this:


=Num(Count(Distinct {$<QtaGiacente={"<>0"}, AnnoUltimoMovimento={"<$(AnnoInizioObsolescenza)"}>} CodiceArticolo),'#.##0')


But if AnnoInizioObsolescenza is a field then all bets are off. See this document: set_analysis_intra-record.qvw


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Try this:

=Num(Count(Distinct {$<QtaGiacente={"<>0"}, AnnoUltimoMovimento={"<$(AnnoInizioObsolescenza)"}>} CodiceArticolo),'#.##0')

Anonymous
Not applicable
Author

Marc, your answer il right too, but I'm not able to set it so (actually I think it isn't possible ).

Thank you so much to everybody.

N.