Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

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
MVP & Luminary
MVP & Luminary

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

Re: Conditional show in QlikSense

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

Highlighted
mdmukramali
Valued Contributor III

Re: Conditional show in QlikSense

Hi,

have you tried calculation condition option in  Data Handling?

285765.PNG

285765(1).PNG

Partner
Partner

Re: Conditional show in QlikSense

i like to hide the pivot itself

Partner
Partner

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

Partner
Partner

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 ?

Partner
Partner

Re: Conditional show in QlikSense

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

MVP & Luminary
MVP & Luminary

Re: Conditional show in QlikSense

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


getselectedcount([DebCred_Code]) > 0


-Rob

Partner
Partner

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

Partner
Partner

Re: Conditional show in QlikSense

Thnx!