Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
One approach may be use Island table and then create each value calculation in island table.
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
Island table would be created using Inline Load?
Yes
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
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
Hi Mohammad,
As of now, there is no option to hide the headers.
Try exploring some extension objects;
Other wise as a work around , place a text box on top of the header of the straight chart with same background color.
Good Idea Jyotish... but is it possible?
Thanks,
Sarif