Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
francisvandergr
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
rwunderlich

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
MK9885
Master II
Master II

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

mdmukramali
Specialist III
Specialist III

Hi,

have you tried calculation condition option in  Data Handling?

285765.PNG

285765(1).PNG

francisvandergr
Partner
Partner
Author

i like to hide the pivot itself

martinpohl
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

francisvandergr
Partner
Partner
Author

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
Partner
Partner
Author

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

rwunderlich

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


getselectedcount([DebCred_Code]) > 0


-Rob

View solution in original post

martinpohl
Partner
Partner

data handling only is

if true caluclate the object

if not, show message

so

getselectedcount(DebCred_Code)= 1

can be used

francisvandergr
Partner
Partner
Author

Thnx!