Conditional show in QlikSense

[francisvandergr]

In QlikView you have option

Conditional on TAB LAyout.

I wanna have pivot table only when i select 1 customer:

Conditional:

=count(distinct(CDDEBITEUR))='1'

Is this possible in Sense?

[MK9885]

You to show/hide a column in Pivot table or show/hide a Pivot Table itself?

[mdmukramali]

Hi,

have you tried calculation condition option in  Data Handling?

[francisvandergr]

i like to hide the pivot itself

[martinpohl]

it is not possible like in Qlik View

you can hide the object by security rules but then there is a message that the object isn't available.

a good possibility is to use Qlik Sense objects (charts or tables) by a mashup in a browser page. there you can hide the object without the message, but the place will be shown empty

[francisvandergr]

Then the best way is by data handling i think. But this does not work.

=getselectedcount(DebCred_Code='1',DebCred_Code).

When one DebCred_Code is selected it must be visable. Something wrong in Formula ?

[francisvandergr]

this also not work: =if(getselectedcount(DebCred_Code='1'),DebCred_Code)

[rwunderlich · Accepted solution]

The Calculation Condition requires an expression that returns True or False. So try:

getselectedcount([DebCred_Code]) > 0

-Rob

[martinpohl]

data handling only is

if true caluclate the object

if not, show message

so

getselectedcount(DebCred_Code)= 1

can be used

[francisvandergr]

Thnx!