topic Re: Basic questions in QlikView

Basic questions

Fri, 29 Nov 2013 13:00:09 GMT

HI,

Added to LISTBOX Q unnecessary. How do I delete it (Q without a number).

What is the formula for bringing the names of days? I used with DayName

This resulted in the dates.

Budget Sheet: How can I make it every year will be the same budget. If I click in the list box in the cloud for 2007 it will give me the result as in 2010 (888).

Last question, and most important: how to make the most appropriate links between the tables with JOINS''

I do not know how to do JOIN between tabs.

Re: Basic questions

rustyfishbones — Fri, 29 Nov 2013 13:18:50 GMT

Hi Alon,

first problem you have is that you have dates in a number of tables, link the Sales to sales history

using concatenate something like

the formula for days is WeekDay(Date) as Day

Re: Basic questions

rustyfishbones — Fri, 29 Nov 2013 13:23:46 GMT

Hi,

to disregard the selection for year try adding the expression SUM({<Year=>}SalesAmount)

see below

Re: Basic questions

rustyfishbones — Fri, 29 Nov 2013 13:31:48 GMT

Added to LISTBOX Q unnecessary. How do I delete it (Q without a number).

do you have a blank orderdate in your dataset? it could be causing the issue

Regards

Alan

Re: Basic questions

rustyfishbones — Fri, 29 Nov 2013 13:34:29 GMT

I may have misunderstood an earlier question, if you only want to see 2010 budget regardless of any other year being selected use the following formula