Bonjour,
Je cherche à faire un setanalysis qui me renvoi un montant sur la dernière date trouvé par rapport à un champ " Accepte ".
Je viens de faire cette formule s...
Hi, I've below sample data. ID ID1 Period Type Type1 1 12 2023004 1 1 1 13 2023004 1 0 2 14 2023005 1 1 In the Front End I'm using the below setanalysis expression and I got the output as '2...
Hi,
i have this expression that works fine in qlikview: sum({<DTREG={'<=$(=DATE(MAX(DTREG)))'},ID_FATTURA={"=fabs(round(sum({<DTREG={'<=$(=DATE(MAX(DTREG)))'}>}DARE)-sum({<DTRE...
Hello everybody, I have setanalysis within a chart that has below syntax: count(distinct { <Primary_Product_Flag={1}, Target_Product=,Sales={"=sum(Sales)>0"}, Product_Code={"=s...
...ffective={"=$(MAx({<Taxable={1}, Group={ '0000'}, Item ={ '000'}, TaxType={'03'}>} Effective))"}>} distinct TaxRate) If I replace my setanalysis inside set to find the max d...
...he last working day. i'm using this setanalysis : SUM({$< %Date = {'=Max(%Date)'}>} [Qté Stock] ) but it's not working, do someone know why ? For exemple : my data looks l...
In setanalysis,
category names& unit price:
sportswear-500
men's clothes-880
women's clothes-900
the value of
=sum({<categoryname={men'swear>}unitprice)
s...
Hi all, I am trying to store the selected values in a variable, then use the variable in setanalysis. Method 1: step1: create variable vMonth=GetFieldSelections(Months in List box), step2: in set...
I would like to know the sales values when Top BU is null. I tried the below expression but it is not working. sum({<[Top BU]={"$(=IsNull([Top BU]))"}>}Sales). I would like to have your sugge...
