topic Re: Loading Exel with group rows in QlikView

Loading Exel with group rows

SSD_KKL — Thu, 12 Jan 2023 15:44:25 GMT

Hello!.

I am trying to read an excel in QlikView where the values of some columns have 2 or 3 options in other rows,
and it is only taking the last value of right.

*The green ones

And I need a table in qlik where each product has the 2 or 3 options in the month and delivered rows.

For example, having the Water product 3 times with January, February and March. Ex:

How could it be done?

Thanks!

Re: Loading Exel with group rows

Luis_Galvan — Thu, 12 Jan 2023 19:07:38 GMT

Hi,

You can try using Peek() function. Here is the help link.

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/InterRecordFunctions/Peek.htm

This function will allow you to grab (peek) a value in the "n" row based on the current record set position. Ex, if you need to peek previous value for Product field, you can use:

Peek('Product')

You might have to look for previous 2 (or 3) rows if you know that wrap text is limited to x number of rows.