Hola buenas tardes,

Agradezco de antemano su atención, mi consulta es de "suma de acumulada en pivot".

Tengo una tabla con las siguientes columnas: Concesionario_atencion, Año_lanza, Mes_lanza y Cantidad.

Deseo obtener 2 Columnas Acumuladas, "Acumulado" y "Acumulado Total"

En la columna Acumulada; se busca la suma acumulada de "Cantidad" por "Concesionario_atencion", "Año_lanza", "Mes_lanza", reiniciando en cada año.

En el periodo Oct-2015, el valor es incorrecta de la columna "Acumulado" lo correcto es la suma de: 539 + 519 =1058, pero muestra 1077 (539 + 519 + 19).

La expresion empleada es:

= aggr( rangesum(above( count({<Año_lanza>}[Fechalanzamiento]),0,rowno(TOTAL))),Concesionario_atencion,Año_lanza,Mes_lanza)

Y la columna Acumulada Total debe mostrar la suma de cada fila y reiniciar al ser un Concesionario distinto "Concesionario_atencion"

Expresion empleada:

= aggr( rangesum(above( TOTAL count({<Concesionario_atencion>}[Fechalanzamiento]),0,rowno())),Concesionario_atencion,Año_lanza,Mes_lanza)

Gracias.

Si necesita mayor aclaració no dude en contactarme.

Saludos

Hi

I have a calculated field (CCY_SETID) in my load statement. Now I need to have the total count of (CCY_SETID) . Please help

TLMMO:

LOAD
SET_ID,
IF(Wildmatch(SET_ID,'*GDS*')=1,NULL(),SET_ID) AS CCY_SETID

FROM
$(file)

Hi, I am currently working on a project that requires me to create a diagonal line on QlikSense Q-Q plot but I dont know how to do that. I have created a scatter plot on QlikSense as attached but now I need to create a diagonal line to see the distribution. Can someone please help me in creating a red diagonal line ?

Under Measure X-Axis: =avg[value]

Under Measure Y-Axis: =NORMINV( 1-(rank(([value])) - 0.5) / count(distinct total [value]) , 0,1)

Hi,

I am new in QlikView and I have the following situation. I have a table from a load with multiple fields and I want to count how many IDs are using the same Product ID in each month. So I need to create a new column named: "check offers" as per below table:

So far my script looks like this:

Table1:
LOAD [D],
[ID Name],
[ID Year Month],
[Product ID],
[Offer Type],
[Month],
[No of products]

FROM
[\\xxxxxl\xxxxx\xxxxx\xxxxx\products.qvd]
(qvd);

Table2:

LOAD
[Product ID] as [Product],
[Month] as [Month_date],
count([Products ID]) as [check offer]

RESIDENT TB1
GROUP BY
[Month],
[Product ID];

But this doesn't bring me the result I want.

Can you help with a solution? I want to keep all columns from my load + create the new column by 2 condition (to count how many IDs are using the same Product ID in each month).

Thank you

I need to connect to a Progress Database for connectivity to Qlik Sense. Has anyone done this before.

I keep hearing OpenEdge but have not used it.

Any thoughts would be appreciated.

Hi,

My amount field has millions, thousands and hundreds as values. How do I convert into Money($) format as "xxxM", "xxxK", and "xxx" based on values in load script? 

Thanks

Malini

Hi 

I have the following scenario:

i have a fact table which has, the following fields:

ItemCode, SupplierCode, DocDate, PurchDocNum, ObjType (has 2 types: 103 and 101 for each PurchDocNum)

my mission is to Flag each combination of: ItemCode&SupplierCode  in PurchDocNum when ObjType =103 

that have combination on ItemCode&SupplierCode when ObjType =101  in a date greater than the date is when  ObjType =103

i atteached csv copy of the data

thank you!

Hi All , 

I have really great confusion over the output of the table ... As I dont see the data after reloading is working properly .

Can you expertise please help me in fixing this ?  please find the attachment of the QVW file

As shown in the below image the data should start from rally tame (Airport BLR 11 and respective rally prj id and rally feature . buthis is not considering this 

Thanks in Advance

Caros amigos,

Tenho uma duvida de com devo proceder para transformar um campo data.

O cenário é esse:

Tenho um campo com a seguinte configuração (ele vem do SQL)

abaixo um exemplo dele:

2021-01-31 02: 56: 04.000

Já tentei algumas coisas, mas nada deu certo ....

O que preciso:

transformar esse campo e obter os seguintes formatos:

1. DD / MM / AAAA

2. Ter somente o ano (AAAA)

3. Ter somente o mês (MM)

Agradeço desde já por compartilharem seu conhecimento!

Hi!

I have users who are charged for IT-services in periods (months) while they are "active" and in some cases after they no longer are employed and are therefore "inactive".

If a user becomes inactive and they  should no longer be charged for IT-services.

I have a CostsAfterLastDayofEmploymentFlag on users.

I want to show a sum (in two different pivot tables below) for IT-services still being debited in the "latest" period.

Using sum({< CostsAfterLastDayofEmpoymentFlag={'Y'},[DataType]={'Actual'}>}[Price (SEK)]) I can see the total that the user has been debited after they became inactive.

I have user X who was active until 202001 (jan), in 202002 (feb) they become inactive. 

User X has been debited a number of services to a total of 18 SEK since she became inactive. I only want to see the 13 SEK total of IT-services still being debited.

IT-Service A - 6  SEK for all periods since she became inactive  period 202002-202102 (feb last year-feb this year ie still being debited)

IT-Service B - 5 SEK for periods  202002-202011 (feb-nov last year no longer being debited after nov)

IT-Service C - 5 SEK for all periods since she became inactive periods 202002-202102 (feb last year-feb this year ie still being debited)

IT-Service D - 2 SEK for all periods since she became inactive periods 202002-202102 (feb last year-feb this year ie still being debited)

So the total since she became inactive is 18 SEK, but only 13 SEK are still being debited.

I only want to see the total of IT-services which are still being debited in the latest period.

So any suggestions as to how I can show only the sum IT-costs still running?

I tried this:

I made a variable vMaxPeriod variable is: =Max({<[DataType]={'Actual'},[Price (SEK)]={">0"} >} [Period])

Then I used the following formula:

If(Sum({$<Period={'$(=$(vMaxPeriod))'},[DataType]={'Actual'},CostsAfterLastDayofEmpoymentFlag={'Y'}>}[Price (SEK)])<>0,

sum({< CostsAfterLastDayofEmpoymentFlag={'Y'},[DataType]={'Actual'}>}[Price (SEK)]),null())

But returns the total of all IT-services debited on the user level after they became inactive 18 SEK but I want to see 13 SEK: