topic Re: is this possible in Pivot? in QlikView

is this possible in Pivot?

Chanty4u — Sat, 16 Nov 2024 21:16:00 GMT

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 .

Re: is this possible in Pivot?

amrinders — Tue, 12 Mar 2019 08:57:45 GMT

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

Re: is this possible in Pivot?

Chanty4u — Tue, 12 Mar 2019 09:27:09 GMT

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 😞

Re: is this possible in Pivot?

Chanty4u — Tue, 12 Mar 2019 09:43:41 GMT

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

Re: is this possible in Pivot?

Anil_Babu_Samineni — Tue, 12 Mar 2019 09:48:40 GMT

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

Re: is this possible in Pivot?

nagarjuna_kotha — Tue, 12 Mar 2019 09:55:01 GMT

HI, check the attached one:

Re: is this possible in Pivot?

Chanty4u — Fri, 15 Mar 2019 10:19:00 GMT

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

Re: is this possible in Pivot?

sunny_talwar — Fri, 15 Mar 2019 17:30:43 GMT

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

Re: is this possible in Pivot?

Chanty4u — Fri, 15 Mar 2019 17:40:22 GMT

Hi @sunny_talwar

attached is the updated excel.

Re: is this possible in Pivot?

Chanty4u — Wed, 20 Mar 2019 17:33:59 GMT

Hi @sunny_talwar

attached is the updated excel.

Re: is this possible in Pivot?

Anil_Babu_Samineni — Sat, 16 Mar 2019 13:55:35 GMT

Did you see my application?

When you use ValueList() in your dimension, Why are you not using single measure? Inline table helps to match each record from Loop. Can you simplify with my attachment using single measure?