Make selection / set filter in Qlik Sense App via .NET SDK

[chrislemm]

Hello,

I'm currently developing an .NET App which should control a QS App (making selections/setting filters etc.).

I'm can read the current made selection in the tool live, which is great but I have troubles making selections via my app.

So my question is: How can I make a selection / set a filter on my app?

Like setting a Datefilter, a customer filter to a certain customer etc.?

Dim currentSelection As ICurrentSelection = myApp.GetCurrentSelection
For Each selectedField In currentSelection.Selections
MsgBox("Field: " & selectedField.Field & vbNewLine & "Selected Values: " & selectedField.Selected)
Next

Thank you and best regards

[konrad_mattheis · Accepted solution]

Hi,

this should help your:

myApp.GetField(fielname).Select(filtertext, true);

bye Konrad

[chrislemm]

Thank you for your reply. That was the solution. I have to admit I found out earlier but I did forgot about that post.

But I still have the problem to select multiple filters like f.e. years: 2016,2015 etc.

Can I only set a single filter?

[konrad_mattheis]

Hi,

it should work with filtertext = "2016 2015 2014" as example.

bye Konrad

[chrislemm]

Not working for me . I tried 2016,2015 etc. -> delets my filter; 2016;2015 -> same; 2016|2015 -> same; 2016 2015 -> same.
I tried to pass a array to this function, also not working because the parameter is a simple string.

Best regards

[konrad_mattheis]

Hi,

than you have to go the "hard" way like.

CreateGenericSessionObject as Lisfbox,

Fetch the Data, mark the elements as filtered

Destroy the Object.

Just take chrome an watch the websocket connection

if you click on a filterbox in the currentselection and

change a filter setting.

bye Konrad

[Øystein_Kolsrud]

It sounds like you might want to have a look at this function that makes it possible to select multiple field values:

IField.SelectValues Method

Otherwise, there is this section in the documentation for the SDK that gives guidance on how to work with selections:

Filtering data with selections ‒ Qlik Sense

Best regards, Øystein Kolsrud

[Øystein_Kolsrud]

If you want to do something more advanced, like selecting ranges of values, then you might want to look into using the AppField concept instead:

http://help.qlik.com/en-US/sense-developer/3.1/apis/net%20sdk/html/T_Qlik_Sense_Client_IAppField.htm

http://help.qlik.com/en-US/sense-developer/3.1/Subsystems/NetSDKAPI/Content/WorkWith/Net-Sdk-Work-Wi...

An AppField is a generic object containing a ListObject for a particular filed. That allows you to use the selection mechanisms of generic objects for doing what you want. You can use this method to get an AppField for a particular field:

AppExtensions.GetAppField Method

The AppField object returned by that method provides methods for doing operations on the list box. For instance, this method can be used to select ranges:

http://help.qlik.com/en-US/sense-developer/3.1/apis/net%20sdk/html/M_Qlik_Sense_Client_IAppField_Sel...

[catalin]

Hi, I know its 4 years late, but I was looking for an answer and stumbled on your inquiry. 

Multiple values in the field values of a QS selection is an :

IEnumerable(Of FieldValue)

 Your best bet is to have a class, something like this:

Public Class QSSelection
        Public Property fieldname As String
        Public Property fieldvalues As IEnumerable(Of FieldValue)
End Class

And then you can pass the properties to this class (let's suppose you have a Date field in your QS app and you need to apply, let's say, 56 days in the past, starting from today, as selections:

Dim qs_selection as QlikSelection() = New QlikSelection()
qs_selection.fieldname = "Date" 
Dim today = DateTime.Now().Date
Dim firstday = today.AddDays(-56)
Dim datematrix As List(Of Date) = New List(Of Date)
Dim i As Integer
For i = 1 To 56
    datematrix.Add(today.AddDays(-i).ToShortDateString)
Next
qs_selection.fieldvalues = {New FieldValue With {.Text = Nothing, .Number = 0, .IsNumeric = True}}
For Each zi In datematrix    
    qs_selection.fieldvalues = qs_selection.fieldvalues.Concat({New FieldValue With {.IsNumeric = True, .Number = CType(zi.ToOADate, Integer), .Text = zi}})
Next

And from now on it's pretty simple as you can call the SelectValues() function of the IField interface and give it the IEnumerable(Of FieldValue) from your class. Something like this:

Public Sub ApplySelections(ByVal location As ILocation, ByVal id As IAppIdentifier, ByVal QSSelections As QlikSelection)
  Dim app = location.App(id)
  app.GetField(QSSelections.fieldname).SelectValues(QSSelections.fieldvalues)
End Sub

[Hemik]

Hi,

It's late response but it may help someone.

I was searching the solution for filters with multiple value using dotnet and I found the below solutions and It's working fine.

var fieldLst = new List<FieldValue>();
foreach (string account in accountArray)
{
          FieldValue fieldValue = new FieldValue();
          fieldValue.IsNumeric = false;
          fieldValue.Text = account;
          fieldLst.Add(fieldValue);
}
app.GetField(field).SelectValues(fieldLst, true);

Thanks,

Hemik