Qlink Newbie - Help with simple graphic

[#1]

Hi all,

I'm new in Qlink view. I'd really appreciate your help with an apparently easy graphic I can't create.

I'm getting via database my tables. I have one with the all the sales' list. It has the fields: price, id of vendor and a timestamp with the selling date called transaction_date (format "YYYY-MM-DD hh:MM:mm")

I want to display a lines' graphic with the amount per month sold for each vendor. I don't know how to create the expression for getting the month and to make qlink to know that  transaction_date is the field to check to make the calculations by month.

Could you help me with the expression? (I'd need the txt file as I'm running the free version).

Thank you in advance,

Dani

[sujeetsingh]

So reload the table as

RawData:

SQL select

price, id ,transaction_date,Sales

from table xyz;

Data:

load *,

month(transaction_date) as TransactMonth

resident RawData;

drop  table RawData;

Now in you UI add a bar chart with TransactMonth as  Dimension

and sum(Sales) as Expression.

[Peter_Cammaert]

As an alternative, and especially if you want to report on periods even if they don't have any sales, you can create a Master Calendar from the minimum and maximum dates present in your data. Search for Master
Calendar in the community. You'll find many examples.

Qlink. Good one, hadn't heard it before. It even has some associativeness built-in. Maybe we should call the script engine Qlink, as there is no Qlikking to be done overthere. Only linking.

[Colin-Albert]

If your data spans more than 1 year, monthname(transaction_date) will give year & month for your dimension. Use sum(price) as your expression,and add a listbox on vendor so you can filter the chart by vendor.

[#5]

Thanks Sujeet, Colin and Peter for your help on this.

Fixed.

Dani