topic Re: Linking Inline function data with the Fields in QlikView

Linking Inline function data with the Fields

Mon, 09 Dec 2013 07:05:29 GMT

Hi All,

I have two fields Turnaround Time which is Number and one inline Function.

I want inline function and the data to be linked i.e when i select 0<=2 in the Inline Field then it has to Select 0, 1 and 2 in another Field.

Please check the attached temp.qvw.

Please reply ASAP as its important in my project.

Thanks in advance,

Keerthi K S

Re: Linking Inline function data with the Fields

Mon, 09 Dec 2013 09:35:46 GMT

Hi Keerthi

The basic function of CLASS can be used to classify ranges. I have attached a reworked version of your model to demonstrate this. However, this function continually uses a specific range, whereas you want to classify all values of 10 and above under one value, therefore I've simply added an IF statement to deal with these large numbers.

Please take a look at the attached file and let me know if I got it correct or not.

Regards

Steve

Re: Linking Inline function data with the Fields

Mon, 09 Dec 2013 09:42:25 GMT

HI Stephen,

Thanks a lot

This is what i wanted

Regards,

Keerthi

Re: Linking Inline function data with the Fields

Mon, 09 Dec 2013 09:58:57 GMT

You're welcome.

All the best.