topic Qlikview_Display multiple labels from the same row in one column in QlikView

Qlikview_Display multiple labels from the same row in one column

utilities — Fri, 22 Jul 2022 10:03:36 GMT

Good Day

I have an excel sheet with several hundred columns and I want to combine them into a single column of the app after the load.

Say Meter1, Meter2, Meter3, Meter4, Meter5, Meter6 I have six tabs each pulling in a different meter and concatenating to a field name "Meter".

However, when I use "Meter" not all the numbers show underneath each other. Below is basically what I want to accomplish.

This is from the excel and "Meter" is what I want to display in Qlikview.

Meter1	Meter2	Meter3	Meter4	Meter5	Meter6
456	852	753	951	348	654

Meter
456
852
753
951
348
654

Re: Qlikview_Display multiple labels from the same row in one column

sidhiq91 — Fri, 22 Jul 2022 10:55:05 GMT

@utilities Could you please try something like below in the load Editor Script:

NoConcatenate
Temp:
Load
* Inline [
Meter0,Meter1, Meter2, Meter3, Meter4, Meter5, Meter6
0,456, 852, 753, 951, 348, 654
];

Temp1:
CrossTable (Meter, Values) Load * Resident Temp;

Drop fields Meter0,Meter;

Rename Field Values to Meter;

Drop table Temp;
Exit Script;

If this resolves your issue please like and accept it as as solution.

Re: Qlikview_Display multiple labels from the same row in one column

utilities — Fri, 22 Jul 2022 12:59:15 GMT

Sorry my scripting skills are minimum.

The "inline" load is not an option because there are 100+ spreadsheets with the same set of headings in them and different values under the headings (that stay constant) that may even change from one period to the next.