is this possible in Pivot?

[Chanty4u]

Hi all,

@kaushiknsolanki 

sunny_talwar

MarcoWedel

tresesco

i have case in Qlikview to be shown same a excel output attached .

i have a source as a column with three values but i want to show the total column after two values only .

PFA atatched sample input and output .

[amrinders]

Hey Chanty,

You can achieve this using Pick & Match; please refer to the qvw attached. Only one thing can't be achieved is 

"different sub-header names like SV and Total SV it can either of them".

[Chanty4u]

thanks 🙂 but if i add other measures
EDW SV/total sv tcv, EDW total/totaltcv

its giving me in all the sources with seperate columns 😞

[Chanty4u]

Amrinders im trying to add last two conversion columns   but its giving me extra column for each source,

[Anil_Babu_Samineni]

PFA, Don't have time to calculate measures. That you can play..

[nagarjuna_kotha]

HI, check the attached one:

[Chanty4u]

Hi @Anil_Babu_Samineni   attached is updated  two conversion measures still i can see under datasources

[sunny_talwar]

Can you modify the attached Excel file to match with what you want QlikView to show?

[Chanty4u]

Hi @sunny_talwar 

attached is the updated excel.  

[Chanty4u]

Hi @sunny_talwar 

attached is the updated excel.