Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all ,
I have the data I got from excel. They want to see it in the same format as below on Qlik Sense.
Is it possible to show it in this format?
When I import it into Qliksense, it assigns the value to the first row and shows the other values as zero.
ID | Country | City | Salary |
23452 | TURKEY | İzmit | 10.000,00 |
23452 | TURKEY | İzmit | |
23452 | TURKEY | Osmangazi | |
23452 | TURKEY | Merkez | |
23452 | TURKEY | Gölcük |
You will not be able to replicate this exact format with Qlik's native objects, as far as I know. If you use a pivot and use Salary as the first dimension (or second, or third), you will get a merged cell for that, but it has to be left of the city or it'll get broken down into rows.
use the peek() function to fill-down the values from the previous row
As below
LOAD
ID
,Country
,City
,If(Len(Salary),Salary,Peek(Salary_2)) as Salary_2
From Xyz.xlsx;