Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Classification in a table with min max of a other table

Hello,

I have a problem in my application :

I have a table ABSENCE with a number of days and I want fixe a classification by day.

The classification is create in a excel file to move easy the classification max min.

We have for each class an TrancheID that I want put in the table ABSENCE for linked to the table Classification, a text label of the classification, the number of Day maximum of this class, and the minimum of days of this class.

I want for each line of ABSENCE to have the TrancheID that correspond to his class.

You can find my File Excel and my QVW with this post.

Please if you can help me ^^

Kind Regards,

Bruno

1 Solution

Accepted Solutions
spividori
Valued Contributor

Re. :Classification in a table with min max of a other table

Hi.

See the example, I hope to help you.

Regards.

7 Replies
Not applicable

Re. :Classification in a table with min max of a other table

You can find the new version after this post.

Not applicable

Re. :Classification in a table with min max of a other table

Hello,

You can find the new version of my TEST.QVD with the data.

I don't undertand why it's not works Sad

Please help me if you can understand this.

Kind Regards,

Bruno

spividori
Valued Contributor

Re. :Classification in a table with min max of a other table

Hi.

See the example, I hope to help you.

Regards.

Not applicable

Re. :Re:Re. :Classification in a table with min max of a other table

Thank you very much ^^

You are a genius ^^ Can you explain why you use this forme? and why my function don't work?

spividori
Valued Contributor

Re. :Re:Re. :Classification in a table with min max of a other table

Hi.

I had a similar problem. In your example the variable TRANCHE is null so the load fails, I can not explain it. So I solved this way.

Sorry, my english is poor, i am using google translator.

Regards.

Not applicable

Re. :Re:Re. :Re:Re. :Classification in a table with min max of a other table

No problem my english is not very good too Smiley Wink

Thanks for your help Big Smile, I hope Qliktech see this post I can explain to us this issue?

Kind Regards,

Bruno

spividori
Valued Contributor

Re. :Re:Re. :Re:Re. :Classification in a table with min max of a other table

Hi.

Ok.

Yes, it's a good idea.

Regards.

Community Browser