Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahamed_Qlik
Specialist
Specialist

Table mash up query

Hi

I have one table in my dashboard which I am using in my mashup page.

Table in App:

 

Customer ID Customer Name Customer Address Mobile E-mail Total ( Count of customers)
           
           

 

In my mashup page, I want to display few columns of it as below:

Customer ID Customer Name Mobile

 

Is it possible to achieve this because in mashp page it is using object ID of table which has all the columns but out of this I want to display only few.

Labels (1)
8 Replies
Cascader
Creator
Creator

is mashup using object as html format or image format?

Mahamed_Qlik
Specialist
Specialist
Author

As html format

Cascader
Creator
Creator

in html report edit template, extend the object id and select the columns you only want to show, you need to enclose them in <table> tag with <tr> and <td> as in the following screenshot.  

Mahamed_Qlik
Specialist
Specialist
Author

I think its image not html format

Cascader
Creator
Creator

in this case, I think you need to create a new table that shows only the required columns and use it instead!

Mahamed_Qlik
Specialist
Specialist
Author

Okay But that table I do not want to show in my application.

Cascader
Creator
Creator

you can put it in a sperate sheet and choose from sheet properties,  in the general tab:

show sheet to : conditional. 

in the condition value create a variable in your load statement and you can assign it to zero if you don't want to show the sheet, or 1 if you want to show it. 

look at attachment 

 

 

Mahamed_Qlik
Specialist
Specialist
Author

Hi Ahmed,

Thank you for your valuable response. I know this I can achieve in QlikView but want to make sure if it can be achieve in Qlik sense as well ?