Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Pivot Table

Hi,

I have a requirement which may sound simple.. but I am not able to get it right...

Below in my data:

idloctimecodetextnumber
123abc2:00 PM12dfg1
123abc11:30 PM45dxf2
123abc4:00 AM33xcvbn3
123abc3:30 PM67vb n4
123abc1:00 PM98bnh5
123abc2:45 PM24bnhghj6
234ghy3:30 PM24hgj7
234ghy1:00 PM33gbn8

and the format in which i need it is:

code1text1number1time1code2text2number2time2code3text3number3time3
id1loc1
id2loc2
id3loc3

draggin the blue line gave me 4 different rows... any ideas please..

Regards...

6 Replies
filosofo
Contributor

Re: Pivot Table

Hi, create three dimensions in your pivot (id, loc and number). And then pivot the number-dimension up over your expressions; code, text and time. Regards, Sander

Not applicable

Re: Pivot Table

can you please post an example...

filosofo
Contributor

Re: Pivot Table

Hi, see attached. Regards, Sander

Not applicable

Re: Pivot Table

thank you.. this is how i wanted it but sorry to ask another question, if i do not want number field in the table.. then what is the alternative?

Not applicable

Re: Pivot Table

any ideas ??

filosofo
Contributor

Re: Pivot Table

Hi, you need a unique key here. Skipping 'number' means that you'll have to define another id. Else revert back to a plain table box. Regards, Sander

Community Browser