Welcome to Qlik Community

Hi,

I have a line chart which shows the trend of  sales by week . I used the data refreshed date  as date field , it was every monday . 

So , my requirment is I have to show the Average trends by month using the Date . How to show the avg percentage by month ? Pls let me know if you required details.

For example june month Avg will be = 96.60+96.64+96.69+96.78+97.06/5  

                                                        =96.75

Thanks,

Hi all.

I have pivot table like below.  I want to color background min and max number by month(Ay) or  like picture right. 

I used  formula like this.  =colormix1(sum(Sales)/Max(TOTAL aggr( Sum(Sales),Month,CategoryName)),yellow(),lightred())

But my pivot tables formula very long as below.  so could you plase help me. 

my pivot table formula:  

if([Net/Brut]='NET', sum(if(month(Veri_Kesit_Tarihi) = Month(Today()) and ([Ürün Durumu]='paymentrequired' or [Ürün Durumu]='continue')
,[Finans Tutarı])),
sum(if(month(Veri_Kesit_Tarihi) = Month([Proje Gerçekleşme Tarihi]) and ([Ürün Durumu]='paymentrequired' or [Ürün Durumu]='continue')
,[Finans Tutarı])))/1000

Thank you.

My Pivot Table: 

Hello All,

Customer is requesting if it's possible to have the the bar chart default to the most recent date so they don't have to scroll to the right everytime they open the Qlikview app.  By default, the Bar chart displays on the first date data is available (see screenshot #1), what we'd like it to default to the current date (screenshot #2).  Any assistance would be greatly appreciated.

Thanks!

Hi dears, hope everyone be safe in your houses 🙂

I am finishing an App in prototype and going to industrialization and that's why I am including SESSION ACCESS with Reduction (this last one is working fine )

Issue: Some users cannot access the App (error: Access Denied), but other users can. Obviously I have checked like 3 times to make sure the users are into the table of users

How am I loading the Users?: As we have some different countries and each one share/access data, we got different folders in the network and the idea is that any country could see only the information of its on country. That's why I created a file inside this folder where I expect the local "app owners" can include the users they want to have access. When someone needs global access, I am the responsible for giving access and I include the user in the appropriate table where only I have access.

Attached the script and also the files I am using. Could someone give me some direction of where should I start looking for?

Thanks, Andrey

Has anyone ever come across this?  I have a straight table that contains 50 rows and when I use NPrinting On-Demand to generate an Excel report using this same table, I only get 35 rows in the report.  However, if I export the table from Qlik Sense directly to Excel, I get all 50 rows.

My company is currently on the April 2020 Release.

Hi Team,

I have  EID,Date(multiple months) and TeamCode.

If i want to check if TeamCode or that EID for that month is same as previous or mentioned month , how do i do it in set anlaysis.

I want count of those EID, whose teamcode for that month is not same as previous/variable month.

About a month ago, our virtual server that houses Qlik encountered a low drive situation where it hit less that 10% available.  While I figured 25GB was still plenty, Qlik didn't like it, and it crashed on me.  We recovered the entire virtual machine from a backup, I cleared out TONS of old logs, and freed up over 80GB of space.  Ever since this event, several of my monitoring apps won't reload.  Most of their error logs are showing a version of this:

20200715T164146.440-0700 0557 SELECT * FROM "public"."view_audit_activity_audit_security"
20200715T164146.440-0700 0558 WHERE entry_timestamp >= '2020-04-15 00:00:00'
20200715T164147.171-0700 Error: Field 'entry_timestamp' not found

I figured since we were running on the November 2019 release, and I needed to perform an upgrade, things would resolve themselves when I went to February 2020.  I've done that this past Monday, and it's still having issues.

So here's my question:  I believe there are QVDs or other supporting data on the Qlik server that I can remove & the apps will rebuild the data sources that they need.  Based on that, can someone point me to links or information on what to remove?  I've done multiple searches, but feel like I can't find specifically what is necessary.

Thank you in advance, and I appreciate your efforts to guide me!

Apps Currently Failing:

1. License Monitor
2. Log Monitor
3. Operations Monitor
4. Reloads Monitor
5. Sense System Performance Analyzer
6. Sessions Monitor

Successful Apps:

1. App Metadata Analyzer (newly installed)
2. Connector Logs Analyzer

This is the employee data, i want create headcount analysis.

I cannot do anything in the script. All data will just get appended anymonth.

User will select 2 months for comparison and 

They want get  New to the company, Retained , Resigned from the company, Internal transfer

this should be valid based on selection of Region, Department and Team

So when i compare June and July Month i  select  only Team (Digital C ), I should get output

New to Bank: 1 (Employee 5555)

Resigned from Bank: 0

Internal Transfer: + 1 (Employee 4444)

Internal Transfer: -1(Employee 2222)

So when i compare June and July Month i  select only Region (East) , I should get output

New to Bank: 1 (Employee 5555)
Resigned from Bank: 1 (Employee 3333)
Internal Transfer: +1 ( Employee 4444 )
Internal Transfer: -0

Note: Any two months can be selected for comparison, Jan Mar, Jan Nov, Feb Apr, June Nov, etc

Hint: Lowest grain is Team Code, If team code of employee is present and not present in last month , he is new to the bank,
if team code of employee is not present this month but present in last month, his has resigned

if team code is present for both month but different and it is same as filter selection, +ve internal transfer,

if team code is present for both month but different and it is  not same as filter selection, -ve internal transfer

I have a composite key of EmployeeID,Teamcode at the backend if useful

Hi all,

we want to create column  based on measures, for sample as below, could you help to share some ideas? Thanks in advance.

For below screenshot what we can achive in Qliksense now, we want to create column, for column C(Budget) and D(Consumption) we create column'A' for them, for E(Scan),F(Second_scan) and G(Retailer_Scan), we create column 'B', for H(Budget%),I(Second_Scan%) and J(Retailer%) we create column 'C'.

Below screenshow was what we want to achive,

Is it possible for this setting in visualization level? Thanks.

Best Regards,

Haifeng