topic Re: Load records where value is in multiple fields in QlikView

Load records where value is in multiple fields

Sun, 20 Sep 2015 22:20:41 GMT

I'm new to Qlikview and need help with this. I have massive records from patient treatment where surgical procedures (eg 'NGD10') is stored in multiple fields (eg. ncsp_1, ncsp_2...ncsp_10). What I need is to do a loop/repeat to just pick out records that have a specific value using either match or wildmatch function. Can someone please show me how to do it in script?

Re: Load records where value is in multiple fields

parthakk — Mon, 21 Sep 2015 11:38:44 GMT

Hi Daniel,

U mean u want to eliminate the null values? And are you applying croostable upon this?

Thanks,

Partha K

Re: Load records where value is in multiple fields

Ralf-Narfeldt — Mon, 21 Sep 2015 11:40:33 GMT

Can you share an example of your data set? And maybe an example of your desired result.

Re: Load records where value is in multiple fields

Anonymous — Mon, 21 Sep 2015 11:43:22 GMT

Do you need the records which are having NGD10 in all the columns you mentioned ?

you can use where clause in script.

Can you elaborate more .

Thanks

BKC

Re: Load records where value is in multiple fields

Mon, 21 Sep 2015 13:30:05 GMT

Partha: U mean u want to eliminate the null values? And are you applying croostable upon this?

No and don't want to apply crosstable because it will make number of rows much more than we can handle

Balkumar:

Do you need the records which are having NGD10 in all the columns you mentioned ?

you can use where clause in script.

Yes, I like for example to mark or just pick records that have "NGD10","GBD20","GFC*". The values can appear sometimes in ncsp_1, sometimes in ncsp_2 etc. How can I write this with a Where-clause? Do I need a For Each loop?