QlikView App Dev

Report Inappropriate Content · ‎2017-06-22

Hi all

I have text file.substring values are

file1 india,hyd pune

file1 india,hyd,chennai

i want to display only pune chennai.how can i do this?

prma7799 · ‎2017-06-22

Why you want to use substring here you have other way to do it.

Please share some sample data with expected output.

Anil_Babu_Samineni · ‎2017-06-22

May be use?

If(Match(file1, 'pune','chennai'), file1)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Anonymous · ‎2017-06-22

Hi,

Do you have this value in your table ? then you can use filter condition.

Please share some sample files for better understanding