Classification in a table with min max of a other table

[#1]

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

[#2]

You can find the new version after this post.

[#3]

Hello,

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

I don't undertand why it's not works

Please help me if you can understand this.

Kind Regards,

Bruno

[spividori · Accepted solution]

Hi.

See the example, I hope to help you.

Regards.

[#5]

Thank you very much ^^

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

[spividori]

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.

[#7]

No problem my english is not very good too 😉

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

Kind Regards,

Bruno

[spividori]

Hi.

Ok.

Yes, it's a good idea.

Regards.