Hi,

I need load an Excelfile to a QlikView application.  I have tried with the following script :

LOAD
Year,
Week,
%FOKID,
NoPackages
FROM [$(vG.ImportPath)File_to_load.xlsx]
(ooxml, embedded labels, table is QVData);

The file consists of YTD data with Year, Week and %FOKID together with a count of packages (NoPackages).

Now, after loading the application, all the data in the application is "filtered" to show only those weeks and %FOKIDs as in the file - what do I need to change in my script?

Year, Week and %FOKID are all existing fields in the application. NoPackages is new information which will be updated weekly in the file.

We are running QlikView 12.60, May 2021 SR1

Thanks,
Anders

Hello Team,
Want to create one application in Qlikview as Data Checker, this app should check below points-

-Check QVD1 size, if it is 0KB then set Flag1=False 

-Check count of QVD1 >0 then set Flag2='Data is available'

Thanks in advance 

Hi everybody,

I'm trying to join multiple tables in order to make links between my tables and I'm facing an issue when "creating" a new field.

Table 1 - Invoice

• InvoiceId
• InvoiceDate
• JnlType
• InvoiceNo
• InvoiceSite

Table 2 - Order 

• InvoiceId
• DeliveryClientNo

Table 3 - Client

• DeliveryClientNo
• ClientNo

Table 4 - ClientMovement

• ID ( which can be obtained with ->Year(InvoiceDate)&JnlType&InvoiceNo&InvoiceSite&ClientNo)

So, I made this but I'm stuck for 2 reasons.

[Invoice]
LOAD
     FactId,
     FactDate,
     FactJournal,
     FactNo,
     FactSite,
     Year(FactDate) &'|'& FactJournal &'|'& FactNo &'|'& FactSite AS ClientDocNo
FROM [lib://.../invoice.qvd] (qvd);

LEFT JOIN([Invoice])
LOAD
     InvoiceId,
     TEXT(RTRIM(DeliveryClientNo)) 
FROM [lib://...Order.qvd] (qvd);

LEFT JOIN[Invoice])
LOAD
     TEXT(RTRIM(DeliveryClientNo))
FROM [lib://.../Client.qvd] (qvd);

After that, i do not know how to make my link between my CLIENT and INVOICE table and to create the field I need for having the ID of table 4.

Can someone please help me?

Have a nice day

bonjour, je suis sur Qlikview

j'ai une table contenant :

Date, Numéro de compte, vecteur.

Je voudrais identifier par un tag les comptes ayant uniquement un seul vecteur (ex VIBER), ceux qui ont deux vecteurs (ex VIBER et SMS) et ceux qui ont les trois (AlloPari, SMS et Viber).

Quelqu'un aurait-il un solution à me proposer.

en vous remerciant

françois

Hey! I have a problem with locking a variable in my timeline.

Basically my line chart is based on the Fiscal year 21/22 (July 2021 - June 2022).

In this line chart, I have data up until  November.

Afterwards I would like to project future number of the figure, based on a quite simple formula.

The formula I have tried using is the following:

if([Historic PP] <> 0, [Historic PP]

,

RangeSum(Sum([FuturePP])/1000,0,RowNo())*

above(alt((Sum ({$1<[YTD]={'YTD'}>} [Historic PP])+Sum ({$1<[YTD]={'YTD'}>} [Planned V])
+Sum ({$<[YTD]={'YTD'}>} [Actual V]))*alt(1/Sum ({$1<[YTD]={'YTD'}>} [Historic PP]),1)))

+RangeSum(Sum ({1} {$<[YTD]={'YTD'}>} [Historic PP])/1000*

above(alt((Sum ({1} {$<[YTD]={'YTD'}>} [Historic PP])+Sum ({1} {$<[YTD]={'YTD'}>} [Planned V])
+Sum ({1} {$<[YTD]={'YTD'}>} [Actual V]))*alt(1/Sum ({1} {$<[YTD]={'YTD'}>} [Historic PP]),1)))

)

Where the first part of the if statement is working. However, the second part the variable [FuturePP] will vary from December 2021 till June 2022, and the other part of the formula is varying from June 2021 til November 2021.

In this formula, I would like to use the calculated value at November 2021, and then have the same constant timed on [FuturePP] from December 2021-June 2022.

To elaborate the last part of the if/else statement works if I hardcode the constant (example below)

RangeSum(Sum([FuturePP])/1000,0,RowNo())*

0.5

+RangeSum(Sum ({1} {$<[YTD]={'YTD'}>} [Historic PP])/1000*

0.5

Can anybody help here?

Bonjour,

je cherche à calculer le chiffres d'affaire :

• exemple decembre 2021 vs decembre 2020
• du mois précédent du mois selectionné (ex 2021/11 vs 2021/12)

J'ai chercher dans la communauté mais pas trouvé de solution à ma simple demande.

En vous remerciant

François

I've dropped the App with exported data below.

How would one go on about this? I would like to show/display every customer who haven't placed an order for the past 6 months. I'm very new to this so any help would be appreciated. 

Hallo zusammen,

ich habe in meiner App eine Spalte die mit verschiedenen Werten gefüllt ist. Die Werte sehen zum Beispiel so aus:

2021PL9045

2021TZ4567

2021MN0912

Ich habe jetzt alle Werte aus dieser Spalte mithilfe der wildmatch Funktion in neue Spalten aufgeteilt, nach einer bestimmten Variable, z.B.:

Spalte PL

Spalte TZ

Spalte MN

Jetzt wird in der Spalte "PL" anstatt "2021PL9045" ein numerischer Wert wiedergegeben, z.B. 0,1,2,3,4 usw. Kann ich anstatt der Zahlen auch die vollständige Bezeichnung aus der Spalte anzeigen lassen, z.B. "2021PL9045"?

Danke für eure Hilfe.

Hi,

can anybody explain how to set a dynmic filter in application automation?

I want to select in field Year month the value of actual month, in expression it would be date(today(),'YY MMMM').

Thank you