Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

francisvandergr
Contributor II

Conditional show in QlikSense

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?

1 Solution

Accepted Solutions

Re: Conditional show in QlikSense

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


getselectedcount([DebCred_Code]) > 0


-Rob

9 Replies
arvind654
Honored Contributor II

Re: Conditional show in QlikSense

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

mdmukramali
Valued Contributor II

Re: Conditional show in QlikSense

Hi,

have you tried calculation condition option in  Data Handling?

285765.PNG

285765(1).PNG

francisvandergr
Contributor II

Re: Conditional show in QlikSense

i like to hide the pivot itself

martinpohl
Valued Contributor II

Re: Conditional show in QlikSense

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
Contributor II

Re: Conditional show in QlikSense

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
Contributor II

Re: Conditional show in QlikSense

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

Re: Conditional show in QlikSense

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


getselectedcount([DebCred_Code]) > 0


-Rob

martinpohl
Valued Contributor II

Re: Conditional show in QlikSense

data handling only is

if true caluclate the object

if not, show message

so

getselectedcount(DebCred_Code)= 1

can be used

francisvandergr
Contributor II

Re: Conditional show in QlikSense

Thnx!