Hi Everyone,

I am trying to sum values based on the GL Account for multiple rows. Similar to the below:

So basically I want to sum the Gross Amount, but only for GL Accounts '408000', '408004', '408005', and '408008'. So I don't want to include '577209'.

So my column should display a total of 17,935.

Could you help me write a function to capture the appropriate data?

Hi Team,

  In Qliksense License Monitor Application the below error occurs. Please help on this ..

Here is the underlying script

(FABS(Sum([Actual Units])-Sum([Forecasted Units]))/Sum([Actual Units]))
*
(Sum([Actual Units])/
Sum(total<[Date]>[Actual Units]))

QV12.30SR3 - QMC displaying “Cluster is down” and the status of all tasks is “Unrunnable"

Description: We have observed that for a few minutes the QV distribution service shows as down and all the tasks in the QMC display the status as "Unrunnable".

And within some 3-4 minutes the QV distribution service resumes automatically and tasks status also changes back to previous status.

We have also observed, that there were two tasks which went into long running state since the "Unrunnable" error occurred on QMC.

Hello

we are working on Qlik View server 12 SR3
we already have a lot of source document with so many tasks defined
Now we want to change the location of the source documents; now if we change path of the source folder will the tasks still be runnable on the documents actually defined on?
Kindly advise on how to do so without losing the tasks and their triggers etc...

Somewhat new to this and could not find any similar articles.

I have a list in column A that have multiple values. I'm trying to create a bar graph where the x-axis is any unique values in column A. Y-axis is to be a total count if that unique value shows up. I've created something in excel, attached, to show what I'm trying to depict as the final graph; however, I'm unable to do it in Qlikview.  Any help would be great, thanks in advance!

Hello,

I'm new in this Community and i would like to submit a question about Security Access in QlikView.

Is it possibile to define an access security on a Dataset based on a specific Field? I would create a single Dashboard, but more than one user could use and interact with it.

I need that every users must see the Dashboard filtered by a specific Field for them (for example "Italy Area Manager" must see only data filterd by Field country = Italy and not other countries, but an Executive must be able to see the Dashboard without any restrictions on country).

is it possible to manage in QlikView and how can I Implement it?

Thank you.

Federico

Hi all, 

I have one large data table with unique reference numbers for all events but I only want to load the data for those reference numbers that exist in three separate spreadsheets (keeping the data from each spreadsheet separate). 

e.g. 

So I only want the following loaded:
Spreadsheet A = reference numbers 2 and 4 (loaded as Ref A)
Spreadsheet B = reference numbers 3 and 7 (loaded as Ref B)
Spreadsheet C = reference numbers 1, 2, 4, 6 and 8 (loaded as Ref C)

Hoping this makes sense to someone! 

QlikView 12.30SR3 - Extra decimal places while exporting data in excel

Description - When trying to do an excel download for a straight table having the 'Number Format Settings' as "Expressions Default" the values are showing up with 14 decimal places in the excel.

We have also tried changing the format to "Fixed to" 5 decimal places and it gave number with only 1 decimal place.

Whilst in 12.10 the decimal places for such straight table setting was 4.

Is there any manual setting where we can change the decimal places to 4 for a straight table?

Hi,

is it possible to change the sort order in the export list of the on demand control? HTML is currently standard. Xlsx should appear as the first value. 

Thanks for your help.