Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Add two Dimensions (quantities)

Hi!


I need your help, I am new to this subject and I would need to know if it is possible to add the different dimensions of which refer to Quantities. Example: I have company A with X Sales (I have defined a dimension "quantityA")

1.PNG

With these data manage to make a Budget and its variation perfectly.


Into ANOTHER pivot table, I have company B where I also have defined a dimension "QuantityB".

3.PNG

I need to do, if possible, a third table (or another chart) where I can see the sum of Both Companies (amounts) I hope I can make myself understood.


Thank you.

1 Solution

Accepted Solutions
ahaahaaha
Honored Contributor

Re: Add two Dimensions (quantities)

Hi Leo,

If I understood you correctly. In the chart we try leave one dimension: YTD Max Date.

Expression: Sum({<ANO={"$(=(max(ANO)))"}>}CANTIDAD) + Sum({<ANO={"$(=(max(ANO)))"}>}CANTIDAD2)

10 Replies
tajmohamed30
Contributor III

Re: Add two Dimensions (quantities)

have your tried adding third expression as =Column(1)+Column(2)

you can modify the column numbers as required, so the resulted form 3rd column(adding 1st and 2nd column in your table)

Not applicable

Re: Add two Dimensions (quantities)

Thanks for your answer.


The problem is that they are two different pivot tables. One for Company A and one for Company B.


I hope you understand.

tajmohamed30
Contributor III

Re: Add two Dimensions (quantities)

Can you pls attach example file

ahaahaaha
Honored Contributor

Re: Add two Dimensions (quantities)

Hi,

You can build a summary table at the download script level (see the attached file.) All comments in the script code.

Regards,

Andrey

Not applicable

Re: Add two Dimensions (quantities)

Thans taj and Andrey,

I'm loocking the sample attach, but, my qty fields have a differet names.

please, see attach.

Thank YOU!!

ahaahaaha
Honored Contributor

Re: Add two Dimensions (quantities)

Hi,

like this (look attached file)?

Not applicable

Re: Add two Dimensions (quantities)

Hi Andrey,

Thank for your answer.

Your sample is great! but, I need apply this theory with these "medidas"

1.PNG SUM 2.PNG

I don't the sintaxys in expression?

Hope you understand.

THanks friend!

ahaahaaha
Honored Contributor

Re: Add two Dimensions (quantities)

Hi Leo,

If I understood you correctly. In the chart we try leave one dimension: YTD Max Date.

Expression: Sum({<ANO={"$(=(max(ANO)))"}>}CANTIDAD) + Sum({<ANO={"$(=(max(ANO)))"}>}CANTIDAD2)

Not applicable

Re: Add two Dimensions (quantities)

GREAT!!!!!!!

Thanks very much Andrey!!!!!!!!!!!!!!!

Community Browser