Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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


getselectedcount([DebCred_Code]) > 0


-Rob

View solution in original post

9 Replies
Highlighted
Master II
Master II

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

Highlighted
Specialist III
Specialist III

Hi,

have you tried calculation condition option in  Data Handling?

285765.PNG

285765(1).PNG

Highlighted
Partner
Partner

i like to hide the pivot itself

Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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 ?

Highlighted
Partner
Partner

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

Highlighted
MVP & Luminary
MVP & Luminary

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


getselectedcount([DebCred_Code]) > 0


-Rob

View solution in original post

Highlighted
Partner
Partner

data handling only is

if true caluclate the object

if not, show message

so

getselectedcount(DebCred_Code)= 1

can be used

Highlighted
Partner
Partner

Thnx!