Welcome to Qlik Community

Hi,

I need to create monthly balance from Jan 2020 to Aug. 2020:

but in some month there is no balance because no transactions has been done.

for the month without data I want to display the previous monthly balance

Find attached data and qvf.

Thank you

Hello guys, I need to launch a stored procedure created on the AS400 DB2 for I platform. Whenever I try to launch, do I get the following error? Is there a way to do this?

The rest of the queries run without any kind of problem.

Any suggestion? 

Thanks in advance

Hi All,

im looking for some advice, i have a text object that will display standard deviation. however i need the calculation to change based on the user input. 

there are 4 fields named "distal" "prox", "distal 2" and "prox 2" in my table. each of these fields have values in them. I need my calculation to know that when the user selects the "prox" button, that it will only display the STD for the values in that  prox field? 

here is my calculation so far, 

"=3*(Stdev(Aggr(Sum(distal),BatchSeq,CATHETER)))"

as you can tell, the above calculation will work for the field "distal" but it wont for the others, is there anyway i can replace the distal with a correct function that will display the correct field once the user selects which one they want to view?

thank you ,

Ciarán

Need to make back button (with Back Action) to back exclude to change one variable.

I mean if couple selection were selected and after it the variable (vShowFilters) changed  click on back button will revert last changes - changes on variable, when need to revert one change before.

Is it possible?

Example attached.

Steps :

1. select couple selections

2. Click to change vShowFilter variable

3. Click on button back

I am creating a task to replicate data from Oracle to SQL server (1 table now, for testing). I get the below error. Can someone plz help me resolve this error.

Stream component 'st_0_Oracle' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_Oracle'.

Qlik Replicate

Hi All,
Does "Insight Advisor Chat" supports browser language settings?
It seems it does not.

Currently Hub is shown with the browser language, while "Insight Advisor Chat" is using English language.
I'm using QSEoW Nov 2020 Patch 1 version.

The same behavior on QSE SaaS.

Please let me know.

Best Regards
Andrea