Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
renuka_sasikumar
Contributor III

How to use between for Alphanumeric Values in if condition.

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

Labels (2)
5 Replies
anushree1
Valued Contributor

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

Hi Renuka,

Could you please elaborate along with a sample attachment.

It does 'nt seem to be very clear

 

renuka_sasikumar
Contributor III

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

Attached the App.

anushree1
Valued Contributor

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

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  

renuka_sasikumar
Contributor III

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

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.

renuka_sasikumar
Contributor III

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

Anyone have any work around for this.

It will be helpful.