Welcome to Qlik Community

Hi!

Hope every one is healthy at this time!

I have a question. 

I need a "special period" for Employee Time evaluation in cause of covid! Thank you covid! 😉

I need this Periods for exampe

month march and year 2020 = Value march2020

months march and april and year 2020 = april2020

months march, april, may and year 2020 = may2020 

.... to (for example June2021)

if i chose the value june2020 automaticly them months march, april, max, june and year 2020 should be choosen.

Perhaps i think to complicated but i found no solution for this problem.

Do you have any idea?

Thanks Roland

Hey guys,

can you do something like that in Qlikview? would be awesome because right now I took two charts and it looks like chained together but actally it isnt.

So does Qlikview have this feature?

Hello,

I'd really appreciate some help. I have a requirement, in which I need to get the max of invoice date that is <= to the date a user will select in the dashboard. Basically, we have monthly sales files coming in and for example, if I select the Jan 2019 file, I need to get the latest invoice by item and customer before the end date of that fiscal month for all of the items listed in that file. 

Example:

I have 3 invoices (coming from my invoice table and joining to the file via item number)

Customer ,Item#, InvoiceNumber, InvoiceDate

A, 1234, 786599,1/25/2019

A, 1234, 99999, 12/22/2018

A, 1234, 70888, 1/11/2019

The end of the fiscal month for the Jan 2019 file will be 1/27/2019, which is the Date field. So, the invoice I'd want to get when the user selects that file/date is the first one with date 1/25/2019.

The problem is, if I use Max(Aggr(Max({<InvoiceDate = {"<=$(=Date)"}>} InvoiceDate),Customer,ItemNumber)), I'm able to get that date, but it gives me a completely random invoice in my dimension. I mean, it'll give me an invoice for that item and customer, but it does not match my expression. For example,  in this case, it'll give me the invoice with date 12/22/2018, when it should give me the one with date 1/25/2019. I've tried doing this in the script, I've tried using FirstSortedValue as well. I don't quite understand where the issue is.  Each item number will have multiple invoices by different customers, and I just want the latest one for comparison to see if our invoice price matches what is in the file. Any input will be appreciated.

Thank you.

Hello All,

I have a scenario in Qlik Bar Chart, which grouped.I have 1 dimension ( date field) and 2 measure ( sales and pre-sales). 

I have reference line which is average of sale for the entire date range.

I have implement color of bars based on expression.

If the bar is above Average Sales the bar color is red and if it is below Average Sales bar color is green.

Problem is I also want to have different colors for the Sales Bar and Pre-Sales Bar which are grouped in same date.

Is there a way to achieve this ?

Is it possible to add external users to QMC  through API, Actual scenario is I have List of users in SQL Server DB and I want to add them in QMC. The problem is I don't want to add them using ODBC User Directory Connection  (i.e. restrict access to the database, instead will provide the API).

Any thoughts/suggestion, will much appreciated.

Dear All,

I need a set expression to be written for the last record (RA001A0000030).  This is how it was possible on a simple if statement such as ......IF([B/B/F]<500000 AND [B/B/F]+ADJUSTMENT>500000,[B/B/F]+ADJUSTMENT-500000)). Any idea please?

Thanks

Neville

Hi folks,

Greeting for the day. I need assistance for loading data at perticular time frame. At present I'm looking for loading data on hourly bases and capture the load time in some variable, so I can depict that on report.

I have a script which load and modify data. Should like to update at hourly bases. At present from csv file, but once got link with DB then directly. 

For any query please write back.

Regards,

Sagar.

Hi, I'm new to Qlik Sense and can't figure out the right code to display the get selected items on the div or front end view of a extension.

Below is the code that I'm using. (I'm using Extension for Qlik Sense desktop)

I can get the selected value with this code and display it on the browser console.

I have searched and have not find one of any documentation or examples of  displaying the selected value on a Qlik Sense Extensions. I have some requirements regarding how the selected fields should look. Below is the sample selected fields should look when a field is locked the object will go orange.

this should be look of filter selectedthis should be look when a field is locked the object

Can anybody help me with the right code syntax?

Can anyone clarify me with Tag location field in the below link.I just got confused with this question 

https://www.freecram.com/question/Qlik.QSDA2019.v2020-06-08.q18/a-customer-has-a-dataset-that-contains-latitude-and-longitude-data-for-service-points-around-the-country