Discussion board where members can get started with Qlik Sense.
I'm trying to compare 2 tables which i created with this script:
"Code système U-VM",
where wildmatch("OS-VM", '*Red*')=1;
"Code système U-Name" as "Code système U-VM",
[OS installé sur le serveur]
Drop TABLE Argu;
It work well except that in table chart it give me this
But i'm not supposed to have those lasts field on the right my join was supposed to make appear only result that have a "Code système U-VM". Which is why i'm lost x_x
Go to Solution.
should be enough, I can't see why is important the Argu2 block, that do not provide any new step.
I don't know why seems your table, like Qlik performs right join. I suggest you observe the data in Data Model Viewer preview, to see the underlying table.
Maybe use Outer Join instead of left join?
Or check if you have suppressed the nulls for "Code système U-VM"
I need argu2 to rename the Null into my table since some fields aren't in, i don't want to have them as - since i need to select them in charts.
That's the only method i know to do that unfortunately. Gonna look into the data model then =)
I see, so the final script for the table is not like "LOAD * ...."
Maybe try below script?
If(Len(Trim("Code système U-VM")) = 0, 'Null',"Code système U-VM") as "Code système U-VM."
If(Len(Trim("OS-VM")) = 0, 'Null'," "OS-VM"") as " "OS-VM"." ;
"Code système U-Name" as "Code système U-VM.",
//to get Null instead of '-'
I resigned and did it with the - value.
Thanks for those answers!