Help: how to multiple a fixed number by # of dates... - Qlik Community

Report Inappropriate Content · ‎2013-04-05

Hi Qlikvers,

let's say if i select 10 dates, then 3 should change to 30, now how do i do this calculation in qlikview??

Gysbert_Wassenaar · ‎2013-04-05

Maybe count(total distinct date) * 3

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2013-04-05

Hey Gysbert, i tried your equation and it does not work.

=sum([Max Stops / Day]) * Count(TOTAL DISTINCT [Delivery Date])

kaushiknsolanki · ‎2013-04-07

Hi,

Have a look at the attached example.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Help: how to multiple a fixed number by # of dates selected