At the end of my data load section in the data load script, I've got this bit of code (not working).

    If(IsNull("close_date"), '', Date(Date#("close_date") - open_date)) as new_days_open,
    if("new_days_open" < 14, 'True', 'False') as FlagOnTime;

The first line works but that very last line isn't doing what I expected. Is the syntax incorrect or is the calculated "new_days_open" field unavailable prior to the completed data load?

Hi im having trouble getting a dynamic lable to work in a qliksense app.

I want to name a lable based on two selections.

first is an id and second is a value stateing the type of field. the id is selected from a box while the field_name is the one which will change and can be many different values.

below is the metatable containing the lable names. field_desc is the lable name and field_name is the type. and ctrl_id is the id. 

I try using code like =If(GetFieldSelections(field_name) = 'T_AMT', field_desc) but the lable turn out as - instead of "TAP CHARED MIN" 

Dear All,

I am trying to define a variable with sum involving aggr function in the data load editor. But the aggregation inside the aggr is evaluated. I just want store the expression with out being evaluated as the expression is related the selections made in the front end dashboard.

Ex: I want to store this expr = 'sum(aggr(1, $(=concat('[' & %Dimension & ']', ',' ))))' in a variable in data load editor, but the concat function is evaluated while reloading the dashboard itself and concat function returns null.

Request to provide some suggestions to resolve this issue.

Thanks,

Vidya

Hi all,

This is my scenario:

I have set sheet triggers to select field values in every sheet.After hitting clear button,the triggers setting is also removed and all values are seen which is not ideal.

I refered the answer used in this question https://community.qlik.com/t5/QlikView-App-Dev/Clear-all-selections-removes-the-logic/td-p/1315902

It solves the purpose of retaining the triggers ,however if I clik Clear button for eg on 3rd sheet,it automatically goes to 2nd sheet where the bookmark was created.

Is there any way I can retain the trigger values and also remain on the same sheet ?

hi experts,

looking for some help, apologies in advance as i am new to qlik!

im pulling data from a excel file(attached) and i need to do 2 simple line graphs showing the % of selections in field "mode" and "c" was used in  a certain week. However its not showing up with the correct %'s and i cant understand why? 

im using the wk-YY field as my x-axis in my line graphs. i used the expression "count( [Mode])/count(total "values")" and it works for a single week of data:

but once i select numerous weeks, the line graphs dont have the correct %,(notice the different %  for week 2021-15):

any help in getting the correct formula to show the total % of each mode and C type in a graph per week would be really appreciated

thanks

Hey everyone,

is it in QlikSense possible to use a measure in another measure?

At example we have the first measure "Sales", the second measure "Costs" and want to create the third measure "profit" with "sales" - "costs".

In QlikView there was a possibility to use a measure in another measure using $(sales).

Does anyone know this works in QlikSense?

Thanks and Best Regards,

Fabian