No Mover Data

[Anonymous]

Hi Qlikview Expert,

I want to show no mover report in qlikview. if i select Jan'17 , Feb'17 in month dimension, then i have to show all the name which has zero quantity in both month. if i select all the month, then report shows all the name which doesn't sales any product in that entire selected month.

[kaushiknsolanki]

Try this expression.

Sum({<Quantity = {"0"}>}Quantity)

Regards,

Kaushik Solanki

[Anonymous]

Hi Kaushik,

Thanks for your answer. This expression will give zero value for all the name which don't have any sales in any month. i want that if i select three month, then chart will give the name which don't have any sales in the entire three selected month.