topic Re: Tabular view with Only Measure in QlikView

Tabular view with Only Measure

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a requirement like below and need to implement in Qlik Sense:

I can think one option, to use One Text box with Name of Measure and one Single KPI with expression for each row. But this approach is taking huge space.

Do we have any other option in Qlik Sense to implement this.

Thanks,

Sarif

Re: Tabular view with Only Measure

Anil_Babu_Samineni — Mon, 20 Nov 2017 09:19:59 GMT

One approach may be use Island table and then create each value calculation in island table.

Re: Tabular view with Only Measure

arvind_patil — Mon, 20 Nov 2017 09:23:17 GMT

Hi Mohammad,

First Create Inline Table

DimensionName:

LOad * Inline [

_Dim

Net sale,

Cs Sale

];

And in Measure write if condtion

in dimension add: _dim

Expression:

If(_Dim='Net sale', Expression 1,

if( _Dim='Cs Sale', Expression2

.....

...

))

Thanks,

Arvind Patil

Re: Tabular view with Only Measure

mhmmd_srf — Mon, 20 Nov 2017 09:23:31 GMT

Island table would be created using Inline Load?

Re: Tabular view with Only Measure

Anil_Babu_Samineni — Mon, 20 Nov 2017 09:28:43 GMT

Yes

Re: Tabular view with Only Measure

devarasu07 — Mon, 20 Nov 2017 09:48:36 GMT

Hi,

Try to create Dummy dimension in your pivot table object and then transform your row-into column then it should work

or create data island in back end script or front end value-list method also u can achieve it

Re: Tabular view with Only Measure

mhmmd_srf — Mon, 20 Nov 2017 10:05:17 GMT

Thanks Arvind.

I got my desired out put. Only thing is I need to hide or delete the Column name section.

Can you please suggest me how to do this.

Thanks,

Sarif

Re: Tabular view with Only Measure

jyothish8807 — Mon, 20 Nov 2017 10:34:10 GMT

Hi Mohammad,

As of now, there is no option to hide the headers.

Try exploring some extension objects;

Qlik Branch

Re: Tabular view with Only Measure

jyothish8807 — Mon, 20 Nov 2017 10:35:38 GMT

Other wise as a work around , place a text box on top of the header of the straight chart with same background color.

Re: Tabular view with Only Measure

mhmmd_srf — Mon, 20 Nov 2017 10:40:13 GMT

Good Idea Jyotish... but is it possible?

Thanks,

Sarif

Re: Tabular view with Only Measure

jyothish8807 — Tue, 21 Nov 2017 05:44:40 GMT

Unfortunately overlapping workaround wont work in QS

Re: Tabular view with Only Measure

arvind_patil — Tue, 21 Nov 2017 07:16:23 GMT

Hi Mohammad,

Please close the thread if it serves your purpose.

Thanks,

Arvind Patil