Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Basic questions


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.

4 Replies
rustyfishbones
Master II
Master II

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

2013-11-29_1315.png

the formula for days is WeekDay(Date) as Day

2013-11-29_1319.png

rustyfishbones
Master II
Master II

Hi,

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

see below

2013-11-29_1322.png

rustyfishbones
Master II
Master II

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

rustyfishbones
Master II
Master II

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

2013-11-29_1332.png