Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
The Calculation Condition requires an expression that returns True or False. So try:
getselectedcount([DebCred_Code]) > 0
-Rob
You to show/hide a column in Pivot table or show/hide a Pivot Table itself?
Hi,
have you tried calculation condition option in Data Handling?
i like to hide the pivot itself
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
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 ?
this also not work: =if(getselectedcount(DebCred_Code='1'),DebCred_Code)
The Calculation Condition requires an expression that returns True or False. So try:
getselectedcount([DebCred_Code]) > 0
-Rob
data handling only is
if true caluclate the object
if not, show message
so
getselectedcount(DebCred_Code)= 1
can be used
Thnx!