Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a straight table with one dimension (client) and 2 expressions :
- one for quantity for the selected month
- one for quantity for the YTM based on the selected month.
For some clients, there's no data for the month but there's data for the YTM.
I can't select the client directly in the table if there's no data for the month.
The calculation for YTM is : =Sum({$<Mois={"<=$(=max(Mois))"}>} qte_fact)
For the time selection, I oblige to select only one year and only one month. (I don't know if it's the good solution).
Is anyone having an idea to select client directly in the table ?
Thanks in advance
I can't select the client directly in the table if there's no data for the month.
I don't understand this. If you click on a value in the Code client column then that value should be selected. Are you saying that that does not happen? If so, can you post a qlikview document that demonstrates the problem?
Hi Christelle Henriot , Can you attach the sample file to demonstrate your issue?
Hi,
in the example when I select the Customer K411493, the filter doesn't work. I think it's because there's no data for september 2015.
I think the problem is because I oblige to select only one year and only one month.
Thanks in advance to help me to find a solution to select a Customer even if he has no data.