Display a column on a table, depending on selections.

Fq95 — Fri, 02 Sep 2022 12:43:03 GMT

Hi,

I would like to visualize a column if a certain selection has been made, but, if a combination of other selections (including the first one..) then don't display that column, display another one.

Ex:

I want to visualize a column named Vendor, only if the user selects a toggle called Vendor.

But, if the user, selects Vendor, Distributor, Country, Year and Revenue (Only for that specific combination of toggles, then don't display Vendor, and display another dimension called Vendor 2)..

I created vendor 2, and put the conditions in the conditional view, I only need to don't display "Vendor", when that combination of selections has been made.

Is a pretty rigid app and I can't change the logic... I have to figure out how to do that in the "enable conditional"

Kind regards.

Re: Display a column on a table, depending on selections.

rwunderlich — Fri, 02 Sep 2022 14:42:34 GMT

For Vendor Dimension:

GetSelectedCount(Vendor) and not (GetSelectedCount(Distributor) and GetSelectedCount(Country) and GetSelectedCount(Year) and GetSelectedCount(Revenue))

For Vendor2 Dimension:

GetSelectedCount(Distributor) and GetSelectedCount(Country) and GetSelectedCount(Year) and GetSelectedCount(Revenue)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

topic Re: Display a column on a table, depending on selections. in QlikView

Display a column on a table, depending on selections.

Re: Display a column on a table, depending on selections.