Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
mikejonesnov
New Contributor

How to pivot on an InputField

I want to use a manual input field to be the pivot point for a pivot table, rather than a field from the database.  However each line is being treated as a separate pivot, even though at the moment they all contain exactly the same data.

This is what I currently have (all the inputfield entries are C12345):

But I want it to look like this:

Can somebody help me to get the correct result please?

Many thanks

Mike

1 Solution

Accepted Solutions
el_aprendiz111
Valued Contributor

Re: How to pivot on an InputField

Hi

2 options

1- Calculated Dimension :  =Aggr(Dual(Inputfield, RowNo(TOTAL)), Inputfield, [Ref Series])

2- chart Type = Straight Table

View solution in original post

3 Replies
el_aprendiz111
Valued Contributor

Re: How to pivot on an InputField

Hi

2 options

1- Calculated Dimension :  =Aggr(Dual(Inputfield, RowNo(TOTAL)), Inputfield, [Ref Series])

2- chart Type = Straight Table

View solution in original post

Siva_Sankar
Honored Contributor

Re: How to pivot on an InputField

Can you upload the qvw file?

mikejonesnov
New Contributor

Re: How to pivot on an InputField

Hi Fer Fer

Many thanks for your reply.  Changing the table to a straight table didn't work, but using =Aggr() worked!

Thanks again

Mike