Tabular view with Only Measure

[mhmmd_srf]

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

[Anil_Babu_Samineni]

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

[arvind_patil · Accepted solution]

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

[mhmmd_srf]

Island table would be created using Inline Load?

[Anil_Babu_Samineni]

Yes

[devarasu07]

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

[mhmmd_srf]

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

[jyothish8807]

Hi Mohammad,

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

Try exploring some extension objects;

Qlik Branch

[jyothish8807]

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

[mhmmd_srf]

Good Idea Jyotish... but is it possible?

Thanks,

Sarif