I thought it would be usefull to hear tips and advice as to how to make your app efficient starting with the design,
eg: if you want to group a field into predetermined buckets then its best done in the load script.
Does anyone else have tips like this that will help with efficiency?
What does it mean group of field into predetermined bucket?
On my side, i always do 3 tiers STAR. Pure load from source, business logic and star shcema, the dashboard.
but i think (not very sure, just saying) star has a weakness, just one, the link table tend to grow tremendously.
but, you can reuse the QVD, which is great.
This is some advice i have come accross already from other Qlikcommunity users
From John Witherspoon
Some random ideas:
LOAD date(fieldvalue('MyDate',iterno())) as MyDate
sorry i should have explained further, I've been told if you have a field such as age and you want to show age in the following 'bukets/groups: 0-15,16-30,30+
Then you should create an extra column in your load script which will state which group the age belongs to rather than using an expression.
Wow, those points are really good.
For bucketing yes, should create an extra column.
I have tried to do it directly in dimension, there are not very flexible.
What about the schema? do you always build your app into star schema?
how do u manage it when your data volumn grow?
I did all my renaming during the middle tiers, together with the data volumn, i'm thinking if it would be faster to rename at the first tier. so the middle their can just do optimise load.
I am trying to find an alterantive to a nested if statement.
I have 5 variables and if any of the 5 are true I want to set an expression to true.
is an IF OR statement better?
Or is there any other alternative.
For your 5 variables try:
IF((<Condition1> + <Condition2> + <Condition3> + <Condition4> + <Condition5>) < 0,TRUE, FALSE)
TRUE() equals -1 in Qlikview, therefore if all conditions are True, your total would be -5. Since you only require 1 truth, this formula should work...and no nested IFs.