Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted

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?

Highlighted
Contributor II
Contributor II

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

 

Highlighted
Master II
Master 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.
Highlighted

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.

Highlighted
Contributor II
Contributor II

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?

 

Highlighted
Contributor II
Contributor II

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

 

Highlighted
Contributor II
Contributor II

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

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

Highlighted

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)