Hi all,

I'm using Qlik Sense June 2019 edition.
I've been requested to try enlarging the table font size in a certain app, I'm using a table chart,
the one that comes with Qlik(Not an extension).

Seems like there is no option of adjusting the table text font size over the June 19 edition.
I would like to know if there is a hidden option of font size adjustment for the table chart (Pretty sure there isn't) or if there is an extension that acts as a table and have the setting of font adjustment.

Another option that was offered to me use to use "Sense Theme", I've tried to use it to adjust the font size but it's not applying to the table chart, also seems like there is no option to apply changes over the table chart(Screenshot attached).

Any suggestions?
Thanks.

Hi All

My client has asked me to remove the slash from the zero's

What I found is most of the Apps follow this format. But a few don't. I though it would eb one of the initial SET Statement, But when I copied and pasted the SET statements from the non slash zero App to the slash zero App it make no difference

And help will be appreciated

Thanks Robert

Slash

No slash

Hi, 

Can anyone help me with following if load statement. My files got different column names. So what I want to do is after certain date, I want load different column name. My codes is as follows: 

if(Date(right(FileBaseName(),8))<Date('20210405'),

"Wishlist Visitor","Wishlist Visitors") as "Wishlist Visitor",

The spelling of column name is different for the files that is before that specific date. That codes seems no work.

Can anyone help?

Thanks in advanced

What's the point of using set analysis since it accepts only Data Model Fields and not Dimensions .

1. I see that almost every case where we need set analysis, it can be replaced by a combination of other functions like aggr(), if() etc. So do we really require set analysis?

2. I have a date field in my data model called "order_date" and dimensions "order_year", "order_week" which are derived from "order_date" field using formula Year(order_date) and Week(order_date) . I can't use these two dimensions in my set expressions. For eg, I can't use these dimensions like this 

=Sum({<order_year={"<=$(=vMaxYear)"}>}Sales) 

because "order_year" being a dimension can't be used and this formula will throw an error.   So how do you handle situations like these and does Set analysis even help when I have my Calendar fields as Dimensions? If so, in what cases? 

Thanks in Advance

@Henric_Cronström @sunny_talwar @swuehl 

there are 2000 properties in 10 different countries. Each property has a purchase price.
there are 5 appraisers. Each of them reassess some of the 20 properties.
This leads us to two tables.

1: property, country, purchase price, date of sale announcement, status of sale
2: appraiser, property, estimated price

Table one shows property, country, purchase price overruled by estimated price of selected appraiser if exists (called "current price")

IF(
     ISNULL(ONLY([estimated price by appraiser]))
     ,ONLY($(setexpression) [purchase price])
     ,ONLY([estimated price by appraiser])
     )

where $(setexpression) restricts to specific timeframe when sales have been announced first as well as to specific status of sale

wanted: table two should show the sum of current prices per country (formula above aggregated by country) restricted to properties that fit to $(setexpression) in general