topic Re: varibles in QlikView

varibles

master_student — Mon, 19 Jun 2017 11:53:22 GMT

Hello Guys,

I have a long expression as you can see below :

count ({< Détail ={'Client Perdu','Client Remboursé','Client Retenu','Client Injoignable','Client Migré sans Rétention','Clt Mig sans Rétent'}, Nouveau_statut ={'Fermé Rétention', 'Fermé Rétention CltR', 'Fermé Rétention CltP','Fermé-remboursé','En étude conseiller','Réouverture'}, Spécialité ={'Menace','Mig vers l''offre AWAL Pré','Migration entre offres','Post-payé --> pré-payé','Migration de Forfait Bloqué','Résiliation contrat','Plan d''accompagnement','Changement Plan Tarifaire','Migration de Forfait Bloqué'} >}[Code cas])

can I put it in a variable and use it in other expressions?

if yes, how

Thanks

Re: varibles

sunny_talwar — Mon, 19 Jun 2017 11:57:35 GMT

Do you want to reuse some part of your expression (like set analysis) or the whole thing?

Re: varibles

master_student — Mon, 19 Jun 2017 12:00:14 GMT

the whole thing

Re: varibles

RonaldDoes — Mon, 19 Jun 2017 12:06:27 GMT

Hi Wiem,

Just copy the whole expression into a variable (CTRL+ALT+V) and use $(YourVariableName) wherever it's needed.

It's good practice to start variable names containing expressions with an "e" or "e_".

Re: varibles

sunny_talwar — Mon, 19 Jun 2017 12:06:52 GMT

Then may be just put this in your variable definition

vVar

and then use it like $(vVar)