topic Re: Show values of month and accumulated at the same time in QlikView

Show values of month and accumulated at the same time

mromrod22 — Wed, 25 Nov 2020 16:16:04 GMT

Hi community,

I have a problem. I need create a bars char where show quantity of distinct IDs and accumulated from January to current month.

I create a new dimension Valor_Grafico (dimension that show in char) linking with Calendar through field "Mes":

My expression is from the two cases:

If (Valor_Grafico<>'Acumulado',

sum(aggr(count(DISTINCT {<[Tipo Fecha]={$(vTipoFecha)}, Foto = {'Publicación anual'}, CASO_VALOR_ACTUAL={4}, ESSO_ID_ESTADO*={3,4}>} SOLI_ID_SOLICITUD)

count(DISTINCT {<[Tipo Fecha]={$(vTipoFecha)}, Foto = {'Publicación anual'}, ESSO_ID_ESTADO*={3,4}, SOLI_ID_SOLICITUD*=E({<ESSO_ID_ESTADO*={3,4}, [Transición sin precedente]=, [Tipo Fecha]={$(vTipoFecha)},

Foto = {'Publicación anual'},CASO_VALOR_ACTUAL={4}>}SOLI_ID_SOLICITUD)>} SOLI_ID_SOLICITUD), [Transición sin precedente],Año))

sum(aggr(count(DISTINCT {<[Tipo Fecha]={$(vTipoFecha)}, Foto = {'Publicación anual'}, Mes={"<=$(=max(Mes))"}, CASO_VALOR_ACTUAL={4}, ESSO_ID_ESTADO*={3,4}>} SOLI_ID_SOLICITUD)

count(DISTINCT {<[Tipo Fecha]={$(vTipoFecha)}, Foto = {'Publicación anual'}, Mes={"<=$(=max(Mes))"}, ESSO_ID_ESTADO*={3,4}, SOLI_ID_SOLICITUD*=E({<ESSO_ID_ESTADO*={3,4}, [Transición sin precedente]=, [Tipo Fecha]={$(vTipoFecha)},

Foto = {'Publicación anual'},CASO_VALOR_ACTUAL={4}>}SOLI_ID_SOLICITUD)>} SOLI_ID_SOLICITUD), [Transición sin precedente],Año))

)

My intention is show Valor_Grafico how dimension, and calculate the expression controlling with IF the accumulation condition, but always show the month or the accumulation. Never two.

How can show two values at the same time?

Very thanks.

Bye.

Re: Show values of month and accumulated at the same time

sunny_talwar — Mon, 23 Jan 2017 12:37:29 GMT

Would you be able to share a sample qvw to show the issue and also provide the expected output for the sample qvw provided?

Re: Show values of month and accumulated at the same time

mromrod22 — Mon, 23 Jan 2017 14:03:59 GMT

Select a year and a month. The bar char show month´s value and accumulated to current month. This success, but is a easy example...

Re: Show values of month and accumulated at the same time

sunny_talwar — Mon, 23 Jan 2017 14:48:57 GMT

What would you want to see instead?

Re: Show values of month and accumulated at the same time

mromrod22 — Mon, 23 Jan 2017 14:53:50 GMT

That´s I want see, but not show in the real qw, only I see month´s value or accumulated:

Re: Show values of month and accumulated at the same time

sunny_talwar — Mon, 23 Jan 2017 14:59:12 GMT

Can you convert your chart into a straight table (may be create a copy and do this) and see if you see 0's or a number which is too small to show up on the chart? Also, if you can share a reduced version of your actual application, I might be able to see what the issue is

Preparing examples for Upload - Reduction and Data Scrambling

Re: Show values of month and accumulated at the same time

mromrod22 — Mon, 23 Jan 2017 15:37:13 GMT

Sorry, I can´t share the QW of my client (confidentiallity policy)

Re: Show values of month and accumulated at the same time

sunny_talwar — Mon, 23 Jan 2017 15:47:21 GMT

Did you look at the attached link? It does address confidentiality concerns. You can scramble the data before you add the qvw here

Re: Show values of month and accumulated at the same time

mromrod22 — Mon, 23 Jan 2017 16:58:44 GMT

Yes, I look the link, but I can´t. Prohibited. Sorry and thanks.