Discussion board where members can get started with QlikView.
I have a requirement which may sound simple.. but I am not able to get it right...
Below in my data:
and the format in which i need it is:
draggin the blue line gave me 4 different rows... any ideas please..
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
can you please post an example...
Hi, see attached. Regards, Sander
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?
any ideas ??
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