topic Re: Qlink Newbie - Help with simple graphic in QlikView

Qlink Newbie - Help with simple graphic

Sun, 01 Feb 2015 03:21:36 GMT

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

Re: Qlink Newbie - Help with simple graphic

sujeetsingh — Sun, 01 Feb 2015 04:27:18 GMT

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.

Re: Qlink Newbie - Help with simple graphic

Peter_Cammaert — Sun, 01 Feb 2015 13:05:29 GMT

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.

Re: Qlink Newbie - Help with simple graphic

Colin-Albert — Sun, 01 Feb 2015 14:12:22 GMT

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.

Re: Qlink Newbie - Help with simple graphic

Tue, 03 Feb 2015 13:00:22 GMT

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

Fixed.

Dani