Hi guys,

Is there any way to get rid of the additional blank column within a table.  I haven't set it, so I guess this is a default setting from somewhere.

I only want to show 4 columns !

Thanks

I am a careless person and always make a mistake. Once I deleted my traveling photos on my phone, that was precious memory! I asked on many websites but all I got was a complicated method.

So I had to pay for recovery. I found this software has a very low price, so I tried. try Stillbon Photo Recovery Software. Surprisingly my photos were all back with its help! 

Preciso de ajuda, para criar um qvd de dados que eu leio do Oracle, e com isso eu consigo otimizar minhas cargas, pois toda vez que preciso atualizar meu painel, preciso esperar carregar todos os dados e isso está levando em média 45 minutos, depois disso ainda tenho que subir o arquivo qvf, para a versão Cloud.

Hi, I have problems with this process.

does not respect my condition if it comes in red.

I can Help, Please

tmp_Cuotas_Sucursal:
LOAD distinct
%Pto_vta_ID,
Clasificación_Cuotas,
CuotaUnidades,
Fecha,
// Año,
ValorPorcentual2
FROM
Transformación\Fact\Cuotas_DiariasUnidades2.qvd (qvd)
where %Pto_vta_ID='54NG364' and Clasificación_Cuotas='Mac'
and Fecha>='12/01/2020';

NoConcatenate

Cuotas_Sucursal:
LOAD %Pto_vta_ID,
Clasificación_Cuotas,
CuotaUnidades,
Fecha,
ValorPorcentual2
Resident tmp_Cuotas_Sucursal
where %Pto_vta_ID='54NG364' and Clasificación_Cuotas='Mac'
and Fecha>='12/01/2020'
order by ValorPorcentual2,
Clasificación_Cuotas ,
%Pto_vta_ID
desc
;

Drop table tmp_Cuotas_Sucursal;

//Variable de cuota Total
Ciclo_CuotaTotal:
Load Distinct CuotaUnidades
Resident Cuotas_Sucursal;

Let v_CuotasTotal = peek('CuotaUnidades',0,'Ciclo_CuotaTotal');

trace $(v_CuotasTotal);

//drop table Cuotas_Sucursal;

Drop Table Ciclo_CuotaTotal;

If $(v_CuotasTotal) <= 7 Then

for i= 0 to $(v_CuotasTotal)

Trace $(v_CuotasTotal);

// if '$(i)' <= '$(v_CuotasTotal)' then
//
// let cuota_diaria= 1; Else
// Let cuota_diaria= 0;
//
// trace $(cuota_diaria);
//
left join (Cuotas_Sucursal)
LOAD
%Pto_vta_ID,
Fecha,
Clasificación_Cuotas,
ValorPorcentual2,
CuotaUnidades,
// '$(cuota_diaria)' as ValorPorcentual3,
if($(i)<$(v_CuotasTotal), 1,0) as ValorP,
// ValorPorcentual2
1 as diferente
Resident Cuotas_Sucursal
order by
ValorPorcentual2,
Clasificación_Cuotas ,
// Fecha,
%Pto_vta_ID
desc
;

//ENDIF
NEXT

ENDIF

Que tal!
Tengo un problema y espero puedan ayudarme.
Necesito encontrar los clientes repetidos en mi tabla clientes que tienen la misma informacion pero diferente ID.

¿Que función podría utilizar para comparar los valores de una misma columna y me resulten los repetidos?

Hello,

I have some trouble.

One user have Doc and Named cal's.

We delete doc cal from the assigned users list in qmc, it goes to carantine.

After user still having Named cal, but it have an error message when entering app ( no user cal for your account ).

How can we fix it?

Hi Folks, 

Please assist how can i achieved this,

i want to make a dimension category  by calculating the scenario given below.

I have to calculate this on bases of dimension suppose ID - Retailer

The sample is calculating the value against 1 ID with multiple Retailer.

Please suggest how can i calculate this.

Regards 

Dear all,

I am new with Qlik Sense and I want to ask you for an issue that I have.

I have loaded a table in Qlik and I want to add a calculated column (Add field).

The expression should:

If SySStatus = “TSCO” OR “TSOS” 

then

lookup                  Noti&”_QMAR_”&Task                 Or                           Noti&”_QMAR_”&Task

Lookup in             Offer

if found returns SySStatus

If not returns      Empty

               Else

                                Returns                Empty

Which should be the expression in Qlik to do it?

Thanks