Skip to main content

New to Qlik Sense

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

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Messages on pivot table in qliksense

The messages should displayed according to the following cases

1)User must select the sheet name

2)  post selecting the sheet name and a message should pop up to saying KPI Description also be selected.

after selecting both of them the values should displayed

1 Reply
Partner - Master III
Partner - Master III


your condition should be

count(distinct sheetname)=1 and count(distinct kpidescription)=1

your message should be

if ( count(distinct sheetname)<>1 , 'please select a sheet name' ,

if ( count(distinct kpidescription)<>1 , 'please select a kpi'))