Hi All,
I need to calculate the age of the Employees as on today based on "Date of Birth" column which is available in the Data.

Looking forward for Solution suggestions .

Thanks & Regards,

Manmeet Dhawan

Hi,

I've a date filter in my app which has the dates from 2020 until 2022, I've created a year filter to see only the 2021 and 2022 years in list box using the below expression and is working as expected.

=aggr(only({<Year = {">=$(=year(today())-1)<=$(=year(today()))"}>}Year),Year)

Now my requirement is to create another filter for month and I would like to see data until current month, it means if I select 2021 in year filter I want month's from Jan - Dec and if I select 2022 in year filter I want month's from Jan - July (Current Month).

Regards,

Vikas

@sunny_talwar 

Hello,

I'm hoping someone can help. I've got a chart looking at grades achieved for a particular module. I've hit a bit of a snag however, I'd like each chart to display all the potential grades across the horizontal axis, including those not recorded in the dataset. e.g a module might have any number of the following grades - A+, B+, C, D+, D, F. 

What I'd like to do is include the full list of grades which could have been achieved so the axis would read A+, A, B+, B, C+, C, D+, D, MF, F.

I tried adding in an inline table (see below) and turned on 'show null values' but they don't appear.

LOAD * inline [
Grade
A+
A
B+
B
C+
C
D+
D
MF
F
DF
IN
NC
NR
NS];

Does anyone have any ideas whether this is possible?

Appreciated.

Matt

Hello Qlik Expert!
Sorry if my english is bad.

So as you can see in the subject, right now I want to use the Date Picker extension from Qlik Dashboard Bundle. But when I see in the date field selection, there is no field that I can choose. You can see image below for the proof.

Then I see some another question from Qlik User that have the same problem as me, but all of them load the data not using the SQL like me. 
So for the SQL it self, this is the illustration of it 

In the auto generated section, this field is already tagged as the Date

And I see some reference that I must change the format from my code as like the calendar picker format 

but the result is the same. there is no selection for the date field.

So any suggestions guys ?

I have complex scenario that I am trying to automate that involves running conditional based ETL flows which involve QMC tasks and triggers to decide what QVWs, if any, run.  On the first of the month, I want to start a QlikView QMC task that runs a "pre-check" kind of qvw against a database table to see if 1 (or more) of 3 jobs is ready for Qlik to process, meaning, all the data exists in the database for the respective job. and it is safe for Qlik to process it without leaving out rows.  One of 3 results (single value) will occur from the "pre-check" and dump a qvd with those results that the next QVWs can make decisions on what to do next.   The 3 possible results are Recheck (no job data is ready), Run (1 or more job data is ready), and Done (all 3 jobs have gone through Qlik etl processing).  The Qlik ETL path can run up to 3 times but not more than 3 times, and is dependent upon which jobs are ready according the database that gets loaded into the “pre-check” QVW.

The trouble I am having and don’t know how to code for in the script that will decide what to do once the result value is loaded from the result qvd is how to exit the script if the condition is not met (hence, false) but if the condition is met (hence, true) have the script continue to run which then will trigger the rest of the qvws for my ETL to execute.

So with my data how can I do this:

If result = Recheck then exit script and trigger original QMC to run the “pre-check” load again

    If result = Run then execute the Qlik ETL path, send notification, and trigger original QMC task again

        If result = Done then exit script and send notification and do nothing else

Hello,
I am trying to transfer existing Qlik applications from our QSEoW environment to our Cloud environment.

However, after exporting from QSEoW and importing into the Cloud, all sheets are marked as "Public" but I have no option to make them "Private". I can't delete these Public sheets either.

I am the owner of both the application and the (shared) space. I also tried uploading the app to my Personal space.

How can I solve this?

Hi,

I am facing some strange issues. I can see from the Script log that records have been loaded into tables correctly.

But when I check the table at the App level, can't find any data.

Script log

Data Model view

what could be the reason. Please advise.

Thank you in advance!

Gayatri

Thanks for taking the time to read this....
Can I add a resident load in SQL FROM clause? 

Like so ...

TMP:
SQL SELECT * from table WHERE date_parse(date,'%Y-%m-%d') < date_trunc('month', current_date)
and
date_parse(date,'%Y-%m-%d') >= date_trunc('month', current_date) - interval '1' month

;

Main:

SQL SELECT item, max(date) 
FROM Resident TMP
GROUP BY 1;