topic Re: COUNT WITH DIFFERENT DIMENSIONS in QlikView

COUNT WITH DIFFERENT DIMENSIONS

JMAROUF — Wed, 24 Feb 2021 16:32:53 GMT

Hi everyone,

my goal is to count in the same pivot table events per two different months, however i need just to show one, i'have attached my data model and the output which i want to get, the first table EVENEMENTS contains the categories, scores (SCR1,SCR2..) and creation month, the second table EV_Scannes contains months of scan, i need to show the colored column Part en % which is equal to (number per month creation /number per month of scan).

can any one help please?

Re: COUNT WITH DIFFERENT DIMENSIONS

derekjones — Thu, 25 Feb 2021 15:36:47 GMT

Hi There

I would like to help but I need more information, so are MOIS_GV and MOIS_GED the 'values' in your output or the month names? Whichever it is, I will need the detail of the other field e.g. MOIS_GV and MOIS_GED are values, then where do I find the month names in your tables you have in your output?

Finally SCR1, SCR2 etc are what field/s in your data model (IDGED?)

Thanks

Re: COUNT WITH DIFFERENT DIMENSIONS

Crystel — Fri, 26 Feb 2021 17:57:27 GMT

Count Distinct is the aggregated function present in the tableau. Distinct stands for the unique value of the dimensions or measures. When we create dimension value for the aggregation then the result of the count distinct is get created into measures of the dataset.

jcp associate kiosk

Re: COUNT WITH DIFFERENT DIMENSIONS

JMAROUF — Thu, 25 Feb 2021 21:50:42 GMT

Hi @derekjones ,

Thank you for the reply, MOIS_GV and MOIS_GED are the month names, i have attatched a file for more information, tables A and B are the outputs which i want to get, thank you for advance.

Re: COUNT WITH DIFFERENT DIMENSIONS

derekjones — Fri, 26 Feb 2021 09:50:42 GMT

Perfect, see my proposed solution attached, basically you get the score from EVENEMENTS and applymap it to EV_Scanne using IDGED, then you can convert both MOIS to a single field by concatenating both tables

Let me know if you have any questions

Re: COUNT WITH DIFFERENT DIMENSIONS

JMAROUF — Fri, 26 Feb 2021 11:33:58 GMT

Thank you @Crystel