Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
SSD_KKL
Partner - Contributor
Partner - Contributor

Loading Exel with group rows

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

SSD_KKL_0-1673537309624.png

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:

EXAMPLE 2.png

How could it be done?

 

Thanks!

 

Labels (1)
1 Reply
Luis_Galvan
Contributor II
Contributor II

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/InterRe...

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.

 

BI Qlik Developer || QV || QS || Nprinting