topic Table with data for one month and YTD in QlikView

Table with data for one month and YTD

chenriot — Fri, 04 Sep 2015 13:58:57 GMT

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

Re: Table with data for one month and YTD

Gysbert_Wassenaar — Sat, 05 Sep 2015 08:42:20 GMT

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?

Re: Table with data for one month and YTD

qlikviewwizard — Sun, 06 Sep 2015 02:03:02 GMT

Hi Christelle Henriot , Can you attach the sample file to demonstrate your issue?

Re: Table with data for one month and YTD

chenriot — Mon, 07 Sep 2015 08:43:41 GMT

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.