Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
olguita2014
Creator
Creator

Fields

Hi,

 

please help me!!!!

Load SALDO_ITEM_ANIO,
SALDO_ITEM_ENERO,
SALDO_ITEM_FEBRERO,
SALDO_ITEM_MARZO,
SALDO_ITEM_ABRIL 

FROM [lib://QVD_BASE_LPH/VIS_ITSA_BI_LPH_SALDOS.qvd]
(qvd); 

 

and I trying to make only in two fields, but only I have date of January of 2019:

 

for each vMeses in 'ENERO', 'FEBRERO','MARZO','ABRIL'
Concatenate
Load
'$(vMeses)' as Mes_Saldo,
SALDO_ITEM_ANIO,
SALDO_ITEM_$(vMeses) as Saldo_ITEM
FROM [lib://QVD_BASE_LPH/VIS_ITSA_BI_LPH_SALDOS.qvd]
(qvd);

 

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Have you looked at this approach?

The Crosstable Load

View solution in original post

1 Reply
sunny_talwar

Have you looked at this approach?

The Crosstable Load

View solution in original post