Total in Dim doesn't work in QS Like in QV

[manudenegri]

Hi

I don't know what's happening but I don't have the same result if I make a graph In QV and QS

Dimension:  =if(match(ProveedorFiltroCoda,$(vMarca1),$(vMarca2),$(vMarca3),$(vMarca4),$(vMarca5)),ProveedorFiltroCoda)

Exp1 :SUM(PondeProveedor)

Exp2: sum(TOTAL <ProveedorFiltroCoda> PondeProveedor)

Both columns must be the same

I send a immage with QS and QV Output

need help

Regards

M

[sunny_talwar]

You are saying QV is right, and QS is not? Then why are you even using TOTAL <ProveedorFiltroCoda> if you want the same value to be repeated?

[manudenegri]

Hi Sunny

I have more dimmensions with more complex expressions that I show ... I reduce tge problem to this .... if I solve this I hope solve all my problem.

It's a reduce issue, only this ... can you help me? ... QV is right

Regards

M

[pradosh_thakur]

Hi

From the image, to me it looks like QS is giving correct answer as the two rows have same values with the <total> key word in it.

Can you check if you have any mistake like case sensitivity in the field after total in qv in expression 2?

[sunny_talwar]

I mean if QlikSense is displaying this a little differently, then I don't really think I can tell you what to do. But if you are able to discuss the bigger problem you are facing, may be we can guide you with an alternative way to get to your requirement.

[manudenegri]

Hi Pradosh

I think QS is on the right way, each row must be different, the second column must have the same value than first one.

Expression and project is the same in QV than in QS, Dimmension and expressions are the same (Copy/Paste)

.... any idea?

[manudenegri]

Hi Sunny

I want to have a bar chart graph where onthe axis I have "nets" and I want to have percentages, the problem is when I want to introduce another Dimmension like "Proveedor" ..  Porcentages must be 100% on each "proveedor"

.. that's what's happening

I hope It can help me

Regards

M

[manudenegri]

.. Sorry Pradosh QV is on the right way .... why is different?

[sunny_talwar]

Well just seeing the description of your issue is not very intuitive. Would you be able to share a sample or sample data and based on the sample data, what is that you are hoping to get (in numerical terms)