Show filtered values in one table, and the inverse of the filter in a second table

[Anonymous]

Hey Qlik community, I've got a head-scratcher that I can't seem to find the solution for - not even sure if it's possible! Hoping that you can help me as sort of a last ditch effort.

My app is a list of stores, and the filters that the user can select refer to certain attributes that the store might have.

What I am being asked to build includes a list of all of the stores which have the attributes(easy), right next to a list of all of the stores which do not have the attributes(tough?). I am not sure how I can simultaneously show filtered values, and then in a separate visualization show the inverse.

Furthermore, to complicate things, there are other filters the user can select which should not be affected by this. Meaning, there are five different selections the user can filter by, which will ultimately bring them down to a list of stores remaining in the filter. Then, next to the list of stores, there should be a second list which is affected by four of the filters, and shows the inverse of another filter.

Basically lets say the user has selected A='value1', B='value2', C='value3', D='value4', and E='value5'.

I need to simultaneously have one table that shows all <expression> for which A='value1', B='value2', C='value3', D='value4', and E='value5', and then another table that shows all <expression> for which A='value1', B='value2', C='value3', D='value4', and E <> 'value5'.

Is this possible at all in QlikSense? Any help is appreciated!

[Anonymous]

Hi Alex,

Is this somewhat close to what you're trying to achieve?

If yes, then please use the attached file.

Rgds,

Benazir

[Anonymous]

Hey Benazir what you have there looks great and it looks like it's exactly what I need!!!

But.....the .qvf file you provided doesn't seem to have the sheet on it that you're showing in the screenshot. Did you send an older version of the file?

[Anonymous]

I did send you the right version. When I download the attachment I can see the sheet. Can you send me an email @ benazir@velaninfo.com - I will email the file to you.

PS: can you try downloading from the link below:

https://ufile.io/10orp

[Anonymous]

Here's what I did:

Listbox:

Table with stores where software is installed:

1. Create chart - type: Straight table
2. Add dimension - StoreNumber
3. Add expression:
   • If(SoftwareType = GetFieldSelections(SoftwareType), 'Yes', null())
   • Label: Software Installed?

Table with stores where software is not installed:

1. Create chart - type: Straight table
2. Add dimension - StoreNumber
3. Add expression:
   • If(SoftwareType = GetFieldSelections(SoftwareType), null(), 'No')
   • Label: Software Installed?

These are textboxes:

Hope this helps

PS: this solution will work when user selects only one software at one time. Ensure that "Älways one selected" option is checked in the listbox.

Rgds,

B

[Anonymous]

Thank you Benazir!

It looks like what you have there is a Qlik View solution, which is great.......but sadly I am using QlikSense for this problem. QlikSense doesn't all you to select all of those helpful properties for the straight tables, and doesn't have list boxes, which look like the most helpful part of this.

That's probably why I'm unable to see the sheet as well: I'm opening it up using QlikSense Desktop, not Qlik View.

What you have provided has gotten me closer to a solution, though - I didn't think to use the "GetFieldSelections()" function in QlikSense. Still have a ways to go though.

Thanks for taking the time out to help me with this, I really appreciate it.

[Anonymous]

Happy to help Alex. Maybe you can try this:

https://github.com/ClimberAB/ClimberSelectionBar

It is an extension for Listbox in QlikSense.