Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
LuisM
Contributor III
Contributor III

Dude

Hi all, dude:

I have 2 master items, Cantidad Vendida as Sum(Cantidad) and Nombre Producto

why in my plot has same number for all and it doesnt put correct number in every Product of my plot??

LuisM_0-1651679640633.png

I want that my plot looks in this way, but not happend, why?

LuisM_1-1651679806844.png

 

 

Labels (1)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

What is the relationship between the productos and Comercial

 

Create a table 

Dimension = Productos

Measure = Count({<fecha={"=len(fecha)>0"}>}Largo-Vendedor)

and post a snapshot

 

I think all products from productos are linked to all Largo-Vendedor in Comercial, if that is the case then this is not the field to be used for association

qlikCommunity1.PNG

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

4 Replies
vinieme12
Champion III
Champion III

Please post a snapshot of your master measure and your Data Model

 

There are only two scenarios this can happen

1) Either you have used the TOTAL keyword, which will return total values irrespective of dimension

and so you need not use the Total keyword

 

2) Your Product dimension is not associated to the Quantity measure in your data model

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
LuisM
Contributor III
Contributor III
Author

Hi, here is:

LuisM_1-1651683658464.png

If that is the problem, how can l not use or inactive that? 

Sorry, lm new, thanks l hope your reply 

 

LuisM
Contributor III
Contributor III
Author

This is my data model

LuisM_0-1651684074829.png

 

vinieme12
Champion III
Champion III

What is the relationship between the productos and Comercial

 

Create a table 

Dimension = Productos

Measure = Count({<fecha={"=len(fecha)>0"}>}Largo-Vendedor)

and post a snapshot

 

I think all products from productos are linked to all Largo-Vendedor in Comercial, if that is the case then this is not the field to be used for association

qlikCommunity1.PNG

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.