topic seach multiple values in QlikView

seach multiple values

Mon, 29 Mar 2010 19:14:29 GMT

hello!

i´m having a hard time with qlikview here. I have this multi box, with a field with alot of values (more than 5000). I have 1569 values that i need to select from this multi box....Are there any other easier ways to do it? If i select one each time, it would take forever.

thanks!

seach multiple values

johnw — Mon, 29 Mar 2010 20:21:03 GMT

If the data has a pattern that can be identified with a flag during the load, just add that flag to a table, and select the flag. The 1569 values will be automatically "selected".

If this is just a one time thing, and there's a pattern, such as "all the values I want have the substring 'ABC' in them", then click on the field, type ABC, and hit enter.

If there is no pattern at all to the data, but you'll want these 1569 values to be selected over and over, you could laboriously select them all once, then use a bookmark. But I bet there's a pattern to the data if you'll have continued interest in those specific values.

If it's a numeric field, and you want something like every value less than 2000, click on the field and type in <2000.

You can get pretty advanced with search expressions. From the help text for Advanced Search, you can do things like sum(Sales)>sum(Budget) for a Salesman field to select all salesmen with sales higher than their budget.

seach multiple values

Tue, 30 Mar 2010 13:53:52 GMT

I had the same problem.

I put the value in a excel-file and run this macro.

Hope this can help

Sub

dim

Set

"C:\Partsel.xls"

)

objWorkbook = objExcel.Workbooks.Open _ objExcel = CreateObject("Excel.Application") rad objExcel ReadFromExcel

intRow = 2

intCount = 0

set

Until objExcel.Cells(intRow,1).Value = ""fv = f.GetNoValues f = ActiveDocument.Fields("ArtNrt")

fv.Add

fv(intCount).Text = objExcel.Cells(intRow, 1).Value

intRow = intRow + 1

intCount = intCount + 1

Loop

f.SelectValues fv

objExcel.Quit

End

Sub

Anders

seach multiple values

Tue, 30 Mar 2010 14:00:20 GMT

The macro did´nt look so good. I try again

Sub ReadFromExcel
dim objExcel
dim rad
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open _
("C:\Partsel.xls")

intRow = 2
intCount = 0

set f = ActiveDocument.Fields("ArtNrt")
set fv = f.GetNoValues

Do Until objExcel.Cells(intRow,1).Value = ""

fv.Add
fv(intCount).Text = objExcel.Cells(intRow, 1).Value

intRow = intRow + 1
intCount = intCount + 1

Loop
f.SelectValues fv
objExcel.Quit

End Sub

seach multiple values

Anonymous — Tue, 30 Mar 2010 14:34:26 GMT

I have a macro that I created some time ago that allows you to paste a list from a excel spreadsheet (or any document) into a input box . The macro then scans the list and selects the items from the list. I had posted it to the forum a long time ago. Try that, our users love it.

seach multiple values

gfarrell — Wed, 30 Jun 2010 13:58:13 GMT

Hi Jsomsen,

I noticed this note and tried to find the macro but no luck. Can you send me a sample?

Much appreciated,

gdfarrell