Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Champion III
Champion III

is this possible in Pivot?

Hi all,

@kaushiknsolanki 

 

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 .

Labels (1)
10 Replies
Highlighted
Partner
Partner

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".

 

Highlighted
Champion III
Champion III

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 😞
Highlighted
Champion III
Champion III

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

Highlighted

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

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Partner
Partner

HI, check the attached one:

Pivot.PNG

Highlighted
Champion III
Champion III

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

Highlighted

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

Highlighted
Champion III
Champion III

Hi @sunny_talwar 

attached is the updated excel.  

Highlighted
Champion III
Champion III

Hi @sunny_talwar 

attached is the updated excel.