topic Re: Data from Spreadsheet through transformation not displaying in QlikView

Data from Spreadsheet through transformation not displaying

Thu, 07 Jan 2016 15:00:12 GMT

Dear QV Experts,

The input from spreadsheet, i am trying to transform the data & succeeded 50% but the total not displaying correctly selecting

Metrics. Few of the metrics are correct.

Can you please suggest me on this.

Enclosed the input sheet & qvw.

For selecting Year, 2014, & BCD then it should display,22 but displaying 51. Selected CDE, it should display 58 but in the chart displaying 77.

If selected ABC, for both the years 2014 & 2015, it is displaying correctly.

Appreciate your prompt response.

Thanks,

Sasi

MK_QSL — Thu, 07 Jan 2016 15:02:24 GMT

Try this...

sunny_talwar — Thu, 07 Jan 2016 15:12:13 GMT

New Script:

OccuHealth:

CrossTable(A, OccuData, 2)

LOAD F1 as OccuYear,

[Row Labels] as Metrics,

AA,

AB,

AC,

AD,

AE,

AF,

AG,

AH,

AI,

FROM

Test.xlsx

(ooxml, embedded labels, table is Sheet1, filters(

Transpose(),

Replace(1, top, StrCnd(null))

));

Thu, 07 Jan 2016 15:19:38 GMT

Awesome Sunny!!! Thanks a lot.

sunny_talwar — Thu, 07 Jan 2016 15:28:37 GMT

No problem at all