topic Re: How to display a variable result in a selection list? in QlikView

How to display a variable result in a selection list?

Fri, 27 Jun 2014 14:32:58 GMT

Hi all,

Here is my problem :

I have to import a CSV file and to create an additional variable in order to show the result of this variable in a QlikView document.

Imported data are labelled 'A' and 'G', I want to create a new variable 'vdiff' (A-G) and display it.

Due to the file format of source file I had to add these script line

myTable:

SortieOrganisee_1:

LOAD
Pays_1,
Palier_1,
Variable_1,

//Récupération des variables on utilise le préfixe s_ pour l'onglet Synthèse du CMDB

// Si le palier est de type TAC on place le flag à 1 pour le reconnaître et pouvoir déduire le marketPremium qui ne sert que pour les TACs
if (FindOneOf(Palier_1,'T'),1,0) as s_TACFlag,

// on sépare chaque variable lue dans le champs Palier_1
if (Variable_1='Failure',Données_1) as s_Failure,
if (Variable_1='MarginalCost',Données_1) as s_MarginalCost,
if (Variable_1='MarketPremium',Données_1) as s_MarketPremium,
if (Variable_1='GradientInstalle',Données_1) as s_GradientBrut,
if (Variable_1='AnticipationCost',Données_1) as s_AnticipationCost

Resident SortieBrutReporting_1;
let MissingMoney=sum(s_GradientBrut-s_AnticipationCost);

Until now, I can see the result of "GradientBrut" and "AnticipationCost" but the computed variable is still empty, i used a selectionList with expression and I've selected MissingMoney as an expression (see last screenshot attached)

The datasource is included as an attachement (source.png)

The result displayed is also added as an attachment (Display_variables.png).

Thanks for your suggestions and tricks !

Re: How to display a variable result in a list bow ?

Gysbert_Wassenaar — Fri, 27 Jun 2014 14:40:27 GMT

Use an expression =A-G for your listbox. In the Field drop-down box on the General tab of the listbox properties window select the last item <Expression> and then enter the expression.

Re: How to display a variable result in a list bow ?

Fri, 27 Jun 2014 14:43:17 GMT

Thanks for this answer Gysbert, but it is still empty.

I also tried to put the data in a table as a calculated data but it is still empty

Re: How to display a variable result in a list bow ?

Gysbert_Wassenaar — Mon, 30 Jun 2014 07:13:23 GMT

Then I'm probably misunderstanding what you're trying to do. Can you post an example document with some data and a bit of explanation?

Re: How to display a variable result in a selection list?

Mon, 30 Jun 2014 07:22:15 GMT

Try like this

Let vdiff=sum(A-G)