Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear communty,
Mysenario will be
i have
item amount
item1 10000
item2 0
item3 0
i want to be fill 10000 where amount is 00
kindly guide me
kindly use the below expression for dis[playing amount
if(amount='00' or amount ='Null' ,10000)
Thanks,
D J
Thanks for Reply
but i am not expecting this way it should show the value auttomatically not manuvally
item2 and item 3 shold show item 1 value by dynamically not manuvally
in the future value may be change
Have a look at this document: Generating Missing Data In QlikView
You could try using a peek.
For example:
LOAD
item,
if(isnull(Amount) or Amount = 0,
peek('Amount', -1),
Amount) as Amount
FROM
.....
ORDER BY Amount desc;
Hi, Please find the attached file. I hope the attached file will solve your problem. Regards Sathish
Hi,
lease use the below function to load the data;
LOAD item,
If(Isnull(amount) or amount=0, peek('Newamount'),amount) as Newamount
FROM
Sample.xlsx
(ooxml, embedded labels, table is Sheet1);
Thanks,
D J
This will help you:
If(Isnull(amount) or amount= '0', peek(NewAmount),amount) as NewAmount
Hi
see below result
item | amount | Replace with previous value |
---|---|---|
11008 | 11008 | |
item1 | 10000 | 10000 |
item2 | 0 | 10000 |
item3 | 100 | 100 |
item4 | 0 | 100 |
i4 | 0 | 0 |
i5 | 200 | 200 |
i6 | 700 | 700 |
i7 | 8 | 8 |
i8 | 0 | 8 |
use this cond in ur expression
if(amount=0,Above(amount,1),amount)
then u get this result
above table
1st exp is
amount
2nd exp is
if(amount=0,Above(amount,1),amount)