topic Re: Table mash up query in App Development

Table mash up query

Mahamed_Qlik — Mon, 18 Sep 2023 05:43:07 GMT

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.

Re: Table mash up query

Cascader — Mon, 18 Sep 2023 06:51:56 GMT

is mashup using object as html format or image format?

Re: Table mash up query

Mahamed_Qlik — Mon, 18 Sep 2023 08:26:31 GMT

As html format

Re: Table mash up query

Cascader — Mon, 18 Sep 2023 09:20:08 GMT

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.

Re: Table mash up query

Mahamed_Qlik — Mon, 18 Sep 2023 09:41:28 GMT

I think its image not html format

Re: Table mash up query

Cascader — Mon, 18 Sep 2023 10:43:49 GMT

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

Re: Table mash up query

Mahamed_Qlik — Tue, 19 Sep 2023 05:45:14 GMT

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

Re: Table mash up query

Cascader — Tue, 19 Sep 2023 06:31:28 GMT

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

Re: Table mash up query

Mahamed_Qlik — Wed, 20 Sep 2023 03:49:27 GMT

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 ?