Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

manudenegri
New Contributor

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

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

8 Replies

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

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
New Contributor

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

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
Honored Contributor II

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

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?
Learning never stops.

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

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
New Contributor

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

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
New Contributor

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

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
New Contributor

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

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

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

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)