topic Re: Add 2 Expressions + 1 dimension in pivot table in QlikView

Add 2 Expressions + 1 dimension in pivot table

elie_issa — Tue, 28 Mar 2017 13:41:34 GMT

Dear Concerned,

I am trying to add a pivot table having 2 expressions (Average, Question Index) and 3 dimensions : Questions , Date , Group (Zara,Massimo Dutti , Others)

The 2 expressions should be calculated based on the first 2 dimensions Questions and Date

and another expression should show on the third dimension.

( below is a sample table)

Thanks and Regards,

Elie

maleksafa‌

Re: Add 2 Expressions + 1 dimension in pivot table

vishsaggi — Tue, 28 Mar 2017 13:52:12 GMT

Can you share a sample to look into. And what values you want to see in your Zara, Massimo, others ? A sample output would help.

Re: Add 2 Expressions + 1 dimension in pivot table

elie_issa — Tue, 28 Mar 2017 14:28:40 GMT

Hope the below will help:

The below two objects should be combined in one object as shown in the above requested table.

Re: Add 2 Expressions + 1 dimension in pivot table

vishsaggi — Tue, 28 Mar 2017 15:39:49 GMT

Is it possible to upload a sample file to work on. ?Coz i do not know the expressions and data how it is coming.

Preparing examples for Upload - Reduction and Data Scrambling

Re: Add 2 Expressions + 1 dimension in pivot table

elie_issa — Wed, 29 Mar 2017 06:43:15 GMT

Please Find attached the QVW reduced.

Let me know if you still need any other clarification.

Re: Add 2 Expressions + 1 dimension in pivot table

vishsaggi — Wed, 29 Mar 2017 13:33:57 GMT

Try this may be?

Re: Add 2 Expressions + 1 dimension in pivot table

elie_issa — Thu, 30 Mar 2017 06:29:10 GMT

The solution provided by you is correct but in our case the group dimension is dynamic and the data included in this dimension could change later on so we didn't use this solution in our report.

Thanks a lot and hope we can find another solution.

Re: Add 2 Expressions + 1 dimension in pivot table

vishsaggi — Thu, 30 Mar 2017 13:49:01 GMT

What are the possible values you get in that Group? Can you share an example like how many you will have?

Re: Add 2 Expressions + 1 dimension in pivot table

elie_issa — Fri, 31 Mar 2017 07:30:51 GMT

The values are populated in the script based on an excel mapping file.

so i cannot know in advance what are the possible values.