Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a two rows and all the field values are same except one field value. I have added the fields in chart and try to display both the rows but Qlikview is showing one row (values are same) and the specific field value is displaying as hyphen. I can't upload the file here because of the size and I need to edit only via expressions (Data model already exists and I am getting the results by linking few tables). Any idea about this?
t1:
LOAD R.No,
Name,
Condition,
Prod,
Value,
[Add Value]
FROM
Samp.xlsx
(ooxml, embedded labels, table is Sheet1);
t2:
mapping load Prod as PR,[Add Value] as t2v
Resident t1
where Value='-';
t3:
load R.No as R.Nom,Name as Nam,Condition as Cond,Prod as Product, Value as Val ,applymap('t2',Prod) as [Add Value]
Resident t1
Where Value <>'-';
Drop Table t1
Thanks for your input Robert and great.
Sorry but I need to do it in expression, I can not edit data model (Big one) as it was already created. Could you help me on this.
Hi Tamil you can use as Add Value expression:
If(Condition='PSP', Null(),
only(TOTAL <Prod> {<Condition={'PSP'}>} [Add Value]))
If you have checked supress null values, the row with Condition='PSP' should dissapear and the Add Value populated in the rows of the product.
That expression assumes there is only one Add Value for each product where Condition='PSP'