Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

Hi.

See the example, I hope to help you.

Regards.

View solution in original post

7 Replies
Not applicable
Author

You can find the new version after this post.

Not applicable
Author

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
Specialist
Specialist

Hi.

See the example, I hope to help you.

Regards.

Not applicable
Author

Thank you very much ^^

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

spividori
Specialist
Specialist

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
Author

No problem my english is not very good too 😉

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

Kind Regards,

Bruno

spividori
Specialist
Specialist

Hi.

Ok.

Yes, it's a good idea.

Regards.