Help Required on one of the excercises given in QlikView 11 for Developers book

[Anonymous]

Hi,

I'm currently on chapter no 10, Advance Expression and one the exercises where I've stuck. It is related to the preparation of chart by using the advanced functions like Class, Aggr etc.

This problem is mentioned on page no. 362 of this book and the heading is 'A solo excercise using the Class function'.

If anyone has done it earlier, please help me.

Regards,

[Gysbert_Wassenaar]

I'll try to give you some hints, hoping I don't totally spoil the exercise for you.

Go back a bit to page 351 to Getting the Average Load Factor per Route per Airline. Read page 351 and 352 again to refresh your memory with regards the Load Factor and calculating the average Load Factor.

Now back to your exercise on page 362. Instead of the average load factor per route you want the load factor per Airline. And you want the load factors grouped in classes of 10%.

Now take another look at the expression used for the chart just above the exercise:

Replace( Aggr ( Class ( Count ( DISTINCT [ From - To State Code] ) , 100) , [ Carrier Name] ) , ' <= x <' , ' - ' )

Try to understand what the different parts of this expression do. Can you reuse parts of it? Is it possible to replace a part or parts so it gets the result you're looking for: the load factor... per airline... in bins of size 10?

[Anonymous]

Thanks Gysbert!!!

I was following the same approach but I think I was using the 'Count' function with 'eLoadFactor' that's why it was giving error. But I've rectified that now.

However I'm facing a problem with formatting X axis value to 10-20 etc. from .1-.2 , as the dimension is not available in the Number tab and I explored more where I tried to implement the Num# function directly into the formula, but didn't work. Also I tried to change the 'Text Format' property for the dimension but couldn't suceed.

Can you please provide a suggestion about that also?

Regards,

[Gysbert_Wassenaar]

You probably need to multiply the averages by 100 and then specify 10 as the class size in the class function.