Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys, I'm working on a sales report on qlikview dashboard. I calculate average sales value upto previous month. it's working. But I want to fixed the value in the text box but that's not working. When I choose date or month from the field the average value is changed but I don't want any effect for the average value in the text box. I use a set analysis in the equation. Here is the equation:
=num((Sum({<Month-=,Mday-=,Month-={"$(=vCurrentMonth)"},Year={"$(=vCurrentYear)"}>}Gross_Value)/
(count(distinct {<Month-=,Mday-=>} Month)-1))/1000000,'###0.0')
where, vCurrentMonth=2019
Please help me ASAP, Thanks.
This should work if vCurrentMonth and vCurrentYear are static values.
=num((Sum({<Date=,Mday=,Month={"<$(vCurrentMonth)"},Year={"$(vCurrentYear)"}>}Gross_Value)/
(count(distinct {<Month=,Mday=,Date=>} Month)-1))/1000000,'###0.0')
If vCurrentMonth and vCurrentYear are expressions then you will need to adjust them to so they ignore selections.
This should work if vCurrentMonth and vCurrentYear are static values.
=num((Sum({<Date=,Mday=,Month={"<$(vCurrentMonth)"},Year={"$(vCurrentYear)"}>}Gross_Value)/
(count(distinct {<Month=,Mday=,Date=>} Month)-1))/1000000,'###0.0')
If vCurrentMonth and vCurrentYear are expressions then you will need to adjust them to so they ignore selections.
Thanks that's working