topic Re: How to use between for Alphanumeric Values in if condition. in QlikView

How to use between for Alphanumeric Values in if condition.

renuka_sasikumar — Sat, 16 Nov 2024 04:47:17 GMT

Hello,

I have to build a logic in script end where I have to calculate value on the basis of some filtration.

for e.g.: I have a field named Value, and to check is Record Type = F and Item in (ZABC,ZABD,ZALB, ZANC to ZAX2).

So how should I go about it, I tried by doing this which is not correct, I will have problem in future if there is any new ITEM added in Master.

IF(REC_TYPE=F AND (MATCH(ITEM,ZABC,ZABD,ZALB, ZANC,ZAP1,ZALN,ZAX2)),VALUE) as Value1

Can anyone help me with the solution which doesn't required manual entry in future.

Regards,

Renuka Sasikumar

Re: How to use between for Alphanumeric Values in if condition.

anushree1 — Fri, 11 Jan 2019 07:58:11 GMT

Hi Renuka,

Could you please elaborate along with a sample attachment.

It does 'nt seem to be very clear

Re: How to use between for Alphanumeric Values in if condition.

renuka_sasikumar — Fri, 11 Jan 2019 09:50:09 GMT

Attached the App.

Re: How to use between for Alphanumeric Values in if condition.

anushree1 — Fri, 11 Jan 2019 10:10:18 GMT

Hi Renuka,

I am not sure if I got the requirement right to make things easy i put a inline table which states what are the essential Items you would want to filter and have only those loaded to the Fact so that if the list of essential filters change you can update the Item_check Inline Table and get the required rows.

Hope this helps, if not please explain what you have been actually looking for.

Please check the attachment

Re: How to use between for Alphanumeric Values in if condition.

renuka_sasikumar — Fri, 11 Jan 2019 10:38:30 GMT

Thank You, But this is not what I required. U are defining it as what u required in Item, But there maybe such Item which we don't know but it appears in between ZANC to ZAX2 (Item comes from Master Table).

Plus this is not the only logic which I have to apply, same like I have around 20-30. Currently I am hard coding it using IF condition.

Hope you got what I required it.

Re: How to use between for Alphanumeric Values in if condition.

renuka_sasikumar — Wed, 16 Jan 2019 06:37:05 GMT

Anyone have any work around for this.

It will be helpful.