Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm new to Qlik so what I'm asking might be obvious to many.
I have a field containing the name of the suppliers and a field with the name of the product, (a product can be supplied by more than one supplier).
I would like to know how to have two lines (or more) in a chart where each line represents the trend of supplied products only for a single supplier (preferably set analysis).
Thanks in advance.
If you use a line chart with Date and Supplier as dimensions every supplier will have their own line. But you can no longer have the bars in the same chart.
What do you mean with "the trend of supplied products"?
Please share an example of the data structure and what you want the result to look like.
Something like that (see attachment), i just need to create another line for Supplier B.
Thanks.
You can manually add multiple lines to a combo chart. I didn't rename the measures so you can see what expressions I've used:
However, I cannot enter them manually, because it is a dynamic chart that changes based on the user's filters.
Is there a way to create lines for each individual supplier in a chart automatically?
Forgive me for expressing myself poorly.
Thanks.
If you use a line chart with Date and Supplier as dimensions every supplier will have their own line. But you can no longer have the bars in the same chart.
that's what I thought, why can't you have two dimensions and two measures? 😞