-
Re: Qlik Sense: Line chart with multiple lines
Ruben Marin Feb 2, 2017 4:58 PM (in response to Niklas Andersson)Hi Niklas, just guessing but maybe there are many records for each manual HeadID and not for automatic, if this is the case you can try adding distinct:
Count(distinct InvoiceHeadID)
To retrieve in %:
Count(distinct InvoiceHeadID)/Count(distinct total <ArrivalDate> InvoiceHeadID)
-
Re: Qlik Sense: Line chart with multiple lines
Niklas Andersson Feb 3, 2017 1:04 PM (in response to Ruben Marin )Hi Ruben,
Thank you for the quick reply. However It did not work even though i altered the measurement according to your description
Is there any way I could provide additional information (code perhaps) that would be of any help?
Regards, Niclas
-
Re: Qlik Sense: Line chart with multiple lines
Niklas Andersson Feb 3, 2017 1:07 PM (in response to Ruben Marin )Hi again,
I just got it to work. I had chose the wrong dimension for Arrivaldate, when I selected the Arrivaldate.date as dimension it worked as a charm! Now I have to understand why that is...
-
Re: Qlik Sense: Line chart with multiple lines
Ruben Marin Feb 4, 2017 3:03 PM (in response to Niklas Andersson)If you selected a different field as dimension an it worked most probably is something about the relationships between data, the field used before can be in another table where relationship with count is not clear... Hard to say without taking a look at the or a sample at least.
-
-