topic Re: Need the Result in attached format in QlikView

Need the Result in attached format

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

Need one quick help. I have two different excel which has to be loaded.Once both the excels are loaded i need the output in the exact attached format.

Kindly help.

Regards,

Avinash

Re: Need the Result in attached format

devarasu07 — Tue, 28 Nov 2017 05:13:38 GMT

Hi,

like this

create Pivot table chart object using below expression

try to create below 3 Dimension:

1) Country,

2) ValueList('Registration','ATV')

3) ValueList('Total Registration','Last 7 Day Registration','Total ATV','Last 7 Days ATV')

create Cal.Measure :

if( ValueList('Total Registration','Last 7 Day Registration','Total ATV','Last 7 Days ATV')='Total Registration' and

ValueList('Registration','ATV')='Registration',sum([Total Registration]),

if( ValueList('Total Registration','Last 7 Day Registration','Total ATV','Last 7 Days ATV')='Last 7 Day Registration' and

ValueList('Registration','ATV')='Registration',sum([Last 7 Day Registration]),

if( ValueList('Total Registration','Last 7 Day Registration','Total ATV','Last 7 Days ATV')='Total ATV' and

ValueList('Registration','ATV')='ATV',sum([Total ATV]),

if( ValueList('Total Registration','Last 7 Day Registration','Total ATV','Last 7 Days ATV')='Last 7 Days ATV' and

ValueList('Registration','ATV')='ATV',sum([Last 7 Days ATV])))))

Sort tab:

1) match('India','USA','Russia','Egypt','UK')

2) ValueList('Registration','ATV')

Re: Need the Result in attached format

Anonymous — Tue, 28 Nov 2017 05:16:40 GMT

Thanks,

But how do i do the same formatting in qliksense.

Re: Need the Result in attached format

devarasu07 — Tue, 28 Nov 2017 05:20:45 GMT

Hi,

above mentioned valuelist expression should work in both qliksense and qlikview. just try to follow above steps.

P.S: for qliksense you have to create connection to import your excel source. and remaining steps are same above mentioned.

Close this thread by marking as correct.

Thanks

Deva

Re: Need the Result in attached format

devarasu07 — Tue, 28 Nov 2017 05:34:19 GMT

Hi,

refer to the qliksense version output,

Re: Need the Result in attached format

Anil_Babu_Samineni — Tue, 28 Nov 2017 07:27:47 GMT

Work around seems okay, But it optimize more size. i would prefer to create 2 island tables and use same for Match condition using Pick(Match()).. instead If..Else..