topic Re: data on one line in QlikView

data on one line

Luke_Killer_IT — Mon, 30 Aug 2021 08:42:25 GMT

I would like to see the data from L and H on one line. Is it possible to do that?

I load L and H in the script

Re: data on one line

Taoufiq_Zarra — Mon, 30 Aug 2021 08:42:57 GMT

@Luke_Killer_IT if I understood correctly

in your new dimension :

if(len(trim(L))=0,H,L)

like :

Re: data on one line

yassinemhadhbi — Mon, 30 Aug 2021 08:45:28 GMT

Hi,

Can you share your script please

Re: data on one line

Luke_Killer_IT — Mon, 30 Aug 2021 08:47:22 GMT

Re: data on one line

Luke_Killer_IT — Mon, 30 Aug 2021 08:49:32 GMT

that's more what I meant

Re: data on one line

yassinemhadhbi — Mon, 30 Aug 2021 08:52:24 GMT

it would be better if you shared a sample of your application

Re: data on one line

Taoufiq_Zarra — Mon, 30 Aug 2021 08:56:46 GMT

@Luke_Killer_IT you can try something like

BS_Zuord: Load Owning_Obj as S_Artikel_obj, if(Merkmal='23',Auspr) as L, if(Merkmal='24',Auspr) as H FROM [$(ImportPfadExport)$(Modul)BS_Zuord.qvd](qvd) where SMLeiste='AB-Param' and (Merkmal='23'or Merkmal='24'); final: noconcatenate load Teil, TeilArt,Bezeichnung,concat(L,'') as L,concat(H,'') as H resident BS_Zuord group by Teil, TeilArt,Bezeichnung; drop table BS_Zuord;

Re: data on one line

Taoufiq_Zarra — Mon, 30 Aug 2021 08:58:00 GMT

@Luke_Killer_IT or yous your script

and in UI use chart:

dimension: Teil, TeilArt,Bezeichnung,..

meausre : concat(H,'') and concat(L,'')

Re: data on one line

Luke_Killer_IT — Mon, 30 Aug 2021 09:10:38 GMT

@Taoufiq_Zarra @yassinemhadhbi

teile and teileart uses a different table S_artikel

Re: data on one line

Taoufiq_Zarra — Mon, 30 Aug 2021 10:33:11 GMT

@Luke_Killer_IT the second solution will work for you

Re: data on one line

Luke_Killer_IT — Mon, 30 Aug 2021 10:41:38 GMT

the problem is that teile etc are not in the same table

Re: data on one line

Luke_Killer_IT — Mon, 30 Aug 2021 10:51:56 GMT

does not work correctly because the table BS_Zourd does not have data such as teil teilart etc they are taken from another table