topic Re: Problem In Range in QlikView

Problem In Range

vijayit43 — Fri, 01 May 2015 09:25:47 GMT

Hi Expert,

My Data Format is

FINYEAR	FROMSLABMT	TOSLABMT	CUSTOMERTARGETID
2014-2015	0	50	CLUB-A
2014-2015	50	300	CLUB-B
2014-2015	300	1100	CLUB-C
2014-2015	1100	2600	CLUB-D
2014-2015	2600	100000	CLUB-E

Header 1

and one column in Quantity when total quantity between 0 to 50 then CLUB-A when 50-300 then CLUB-B as so on how to write script on text Object Please Suggest Attached Referance given Bellow..

Re: Problem In Range

Gysbert_Wassenaar — Fri, 01 May 2015 09:33:53 GMT

If I understand your question correctly then you can use the intervalmatch function to match the quantities with the intervals. You'll have to use the extended syntax to make the match for each FINYEAR value. You can find an example here: Re: IntervalMatch Multiplying Records

Re: Problem In Range

vijayit43 — Fri, 01 May 2015 09:57:34 GMT

I cant understand Interval match function please suggest with example

Re: Problem In Range

Gabriel — Fri, 01 May 2015 11:35:04 GMT

Hi,

Read this doc for better understanding of IntervalMatch function.

Re: Problem In Range

vijayit43 — Fri, 01 May 2015 13:36:46 GMT

In Interval Match Function used in Script, But My problem not in Script My Problem In Front end where data change according to filter.

Re: Problem In Range

MarcoWedel — Fri, 01 May 2015 16:44:59 GMT

Hi,

one possible solution could be:

=Only({$<FROMSLABMT={"=FROMSLABMT<=$(vTotalSale)"},TOSLABMT={"=TOSLABMT>=$(vTotalSale)"}>} CUSTOMERTARGETID)

hope this helps

regards

Marco

Re: Problem In Range

vijayit43 — Sat, 02 May 2015 03:05:40 GMT

How to add in Pivot Chart AS Like this.

FINYEAR	CUSTACCOUNT	CUSTOMERTARGETID
2014-2015	CUST/000002	CLUB-A
2014-2015	CUST/000007	CLUB-E

Re: Problem In Range

MarcoWedel — Sat, 02 May 2015 08:12:55 GMT

Hi,

this might be difficult with set expressions because those are evaluated only once per table, not per row.

Please close this thread if your initital question regarding text boxes is answered.

thanks

regards

Marco