Hi, what do i miss here??

if(frac(STARTTIME)>=MakeTime(6,45) and frac(STARTTIME)<=MakeTime(15,29,59),'FM',
if(frac(STARTTIME)>=MakeTime(15,30) and frac(STARTTIME)<=MakeTime(22,59,59),'EM','Natt')) as Shift

How do I create an expression similar to the following?

sum({<Field1={Test1}, [Field2]<>[Field3]>} [Field4])) 

Field4 should be displayed if Field2 and Field3 are not equal. If I create an expression as above, I get an error because <> is not a valid relational operator.

How do I create this correctly?

Hello,

I want my users to be able to add a favorite that selects all the elements in a column > 90. But when I try this, and select 'select all the possible values', it selects all the values of the column without taking in consideration the >90.

Hello everyone,

How do I know if a Job is a "Master" Job, meaning it is not being called from any other Job?
I'm using Talend Studio and I know there is an option accessible by right-clicking on a Job to "Open Job Hierarchy". It shows the flow starting from that Job onwards. But it doesn't show if that particular Job is being called by another Job.
So, my question is: how do I know if a Job I'm looking at is being called by another Job, thus being its child.

Thank you so much.

Rui
 

Hello,

I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender and it has rows for F (as female) and M( as male). Previously, I had this expression behind my filter 
if(Gender='F','Female',if(Gender='M','Male')). it works fine.

Now user wants that every time they open the sheet it filters out the report automatically or by default to Male. and later, if they need then change and select the Female option in the filter.

I have set this variable in the main section in data load editor SET vDefaultFilter='Male', and modify the expression like this: if(Gender='F','Female','$(vDefaultFilter)')

the expression says ok but it does not filter data by default to Male. I still need to go and select Male option.

could someone help please?

Thank you!

I am trying to connect to google BQ I am successfully able to create ODBC connection but not from qlikreplicate getting this error

SYS-E-HTTPFAIL, Cannot connect to ODBC provider.
SYS,GENERAL_EXCEPTION,Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: 08001 NativeError: 10380 Message: [Simba][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[KeyFilePath_Enc]}
 

Discover Qlik's innovative app development, akin to Snapchat's quick yet impactful interactions. Craft user-centric apps, seamlessly integrating data for instant insights. With responsive design, adaptability across devices is seamless. Join us in exploring Qlik app development, where the essence of Snapchat++ APK engaging spirit converges with data-driven decision-making

Hello

I have a table of questions and answers from an account.
Some questions are multi choice and I would like to have a line for each of them.

For example:
QUESTION ID, ANSWER
1, Yes
2, No
3, 1^5^10

For question 3, it is a multi-choice question where the user has selected 3 answers.

I would like to obtain the following final table:

QUESTION ID, ANSWER
1, Yes
2, No
3, 1
3, 5
3, 10

How could I get it?