Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

karthikmungi3
Contributor III

How to create Horizontal expression labels in QLik sense for a pivot table?

Hi,

    How can i create a horizontal expression label in qlik sense for the below pivot chart:-

test.png

In QLikview I would goto Presentation tab and check 'Horizontal' and I would get a output as below

test.png

1 Solution

Accepted Solutions
Not applicable

Re: How to create Horizontal expression labels in QLik sense for a pivot table?

... so the panel on the right (Data) should look something like this:

DataLeft.png

/Pierre

8 Replies
ogster1974
Honored Contributor II

Re: How to create Horizontal expression labels in QLik sense for a pivot table?

Can you mockup how you would like your pivot to look after the change.  Its not clear to me from looking at your example.

Regards

Andy

nagarjuna_kotha
Valued Contributor II

Re: How to create Horizontal expression labels in QLik sense for a pivot table?

please send one sample image and also tell me what kind of view looking for ?

Not applicable

Re: How to create Horizontal expression labels in QLik sense for a pivot table?

Hi Karthik,

Don't know if I completely know what you mean, but I suppose you want to achieve something like this:

PivotSense.png

You seem to need at least two measures to make this work... you could create a new blank measure and add it to the table.

Please let me know if this was helpful to you.

BR

/Pierre

karthikmungi3
Contributor III

Re: How to create Horizontal expression labels in QLik sense for a pivot table?

Hi Pierre,

              That's exactly what I want, could you please say what are your rows, columns and measures? I want the measure labels to the left.Thanks.

Not applicable

Re: How to create Horizontal expression labels in QLik sense for a pivot table?

Hi,

I'm glad to hear that

I just put measures on Rows and added two measures  (any measures you like, but it has to be at least two) and dimensions on Columns.

BR

/Pierre

Not applicable

Re: How to create Horizontal expression labels in QLik sense for a pivot table?

... so the panel on the right (Data) should look something like this:

DataLeft.png

/Pierre

karthikmungi3
Contributor III

Re: How to create Horizontal expression labels in QLik sense for a pivot table?

Thanks Pierre. That was so simple. I was unable to move the \Measures to |Rows previously hence my simple question but now I was able to.

Not applicable

Re: How to create Horizontal expression labels in QLik sense for a pivot table?

No worries! Glad to help