topic Re: Help in set_analysis syntax in QlikView

Help in set_analysis syntax

Anonymous — Fri, 06 Mar 2015 09:58:52 GMT

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.

Gysbert_Wassenaar — Fri, 06 Mar 2015 10:00:59 GMT

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

Anonymous — Fri, 06 Mar 2015 10:02:53 GMT

Try this:

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

Anonymous — Fri, 06 Mar 2015 10:14:30 GMT

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.