topic Using a WHERE clause on a row in QlikView

Using a WHERE clause on a row

Thu, 20 Aug 2009 17:34:34 GMT

Hello,

I have an issue with a spreadsheet which has columns headed M/V and M/R. When this is put into QV it reads these columns as M/V1, M/V2 and M/R1, M/R2 etc. Is there a where clause that can search this particular row and only load the columns which start with M/V?

Thank you,

Paul

Using a WHERE clause on a row

disqr_rm — Thu, 20 Aug 2009 22:41:52 GMT

Not one clause that I am aware of but little trick, with power of what QlikView can do, this can be surely done.

See enclosed.

Using a WHERE clause on a row

Fri, 21 Aug 2009 16:12:45 GMT

Hi Rakesh,

Thanks for your reply. The example that you attached looks good with a text file. However when i change this to an Excel file it cannot find the @1 field. Are Excel rows named something in QlikView, and can these be made a varible?

Thanks, Paul

Using a WHERE clause on a row

disqr_rm — Fri, 21 Aug 2009 23:16:43 GMT

Here you go. Hope it helps.