Use a calculation field in without making it appear in the crosstab

[#1]

Edited by Qlik Community member:

Please post in English unless in a specific language section.

Post translated by Google Translate.

---

Hello,

New on QlikView environment, I am confronted with a problem.

I have a table where I could column Officer in charge of the activity in another column the number of global control that it treated and in another the number of outstanding orders for more than 6 months (180 days)

To know the number of control late I am "If (DELAY> 180 Count (NODDE), 0)" but this calculation only works if in my table I have the "DELAY" dimension that appears.

The problem is that I do not want this dimension to appear

Could someone help me solve this problem?

thank you beforehand

[sunny_talwar]

Are you using Straight table to show the calculation? If yes, then straight table offers to hide a column from displaying:

[#3]

Yes but if I hide the column that does not make me aggregation

I would like the second table. but for now I can only have the first

- - -

Oui mais si je cache la colonne ça ne me fait pas d’agrégation

J'aimerais avoir le deuxième tableau. mais pour le moment j'arrive uniquement à avoir le premier

Note: Edited by Community Moderator to include English translation as a courtesy

[#4]

Hello,

It's good I solved my problem

Instead of having the expresssion

Code :

If (DELAY> 180 Count (NODDE), 0)

expression must be the following

Code :

Count (If (DELAY> 180 NODDE))

- - -

Bonjour,
C'est bon j'ai résolu mon problème

Au lieu d'avoir l'expresssion

Code :

If(RETARD>180,Count(NODDE),0)

l'expression doit être la suivante

Code :

Count(If(RETARD>180, NODDE))

Note: Edited by Community Moderator to include English translation as a courtesy.