Associate Class with Nearest Max and Min

Anonymous — Sun, 21 Aug 2016 17:57:15 GMT

Hello All,

Id	Product	Total Net	Period (Its a Range belonging to User Input year 500)	Class
1	A	10000	504.8	1000
2	B	20000	504.7	1000
4	A	15000	503.6	1000
3	C	25000	503.4	1000
5	B	25000	502.3	1000
6	C	30000	501.8	1000
7	A	20000	500.7	1000
8	B	25000	500.1	1000
9	C	35000	499.8	500
10	A	25000	498.6	500
12	B	30000	498.1	500
13	C	15000	495.2	500

This is a sample data from my project.

I have User Input Box with Variable vYear . If I enter 500 then I get the nearest Max possible value near 500 which is 501.8 and nearest Minimum value Min possible near 500 which 499.8 in a Text Box.

Now, I have a code in my script editor.

NewClass:

Load * Inline{

Min, Max, Classss

1001, , <unknown>

500,1000,1000

250,500,500

100,250,250

50,100,100

,50,50

};

IM:

IntervalMatch(Period)

Load Min,Max Resident Newclass;

So now,

Whenever User inputs vYear = 1000 / 500 /250 /100 /50 in Input Box; my calculations should be like Total Net * vYear but vYear means Nearest Possbile Max and Min. I have to show this in Line Chart.

Dimension - Classs where on X-axis I will have 1000,500,250,100,50 and corresponding values of Nearest Max and Min on Y-axis i.e. Expressions..

How to associate this Classs with the Calculations??

I am very confused. Please help.

Thank you everyone in advance.

Re: Associate Class with Nearest Max and Min

sunny_talwar — Mon, 22 Aug 2016 00:06:04 GMT

Would you be able to share a sample where you have been playing around with this? It would be easier to look at what you have and carry it forward

Re: Associate Class with Nearest Max and Min

Anonymous — Mon, 22 Aug 2016 04:58:37 GMT

Will send the screenshots and codes.

topic Re: Associate Class with Nearest Max and Min in QlikView

Associate Class with Nearest Max and Min

Re: Associate Class with Nearest Max and Min

Re: Associate Class with Nearest Max and Min