From 29 Jun to 22 Jul, we are Qliking into gear and using our pedal power to change the world one bicycle at a time. We are inviting our Community to an immersive digital cycling experience hosted on Zoom and #Zwift (if you’re a rider!) with the amazing host, Olympian and cycling commentator Katherine Bates.
Do More with Qlik - New Qlik Sense Authoring Experience
Join Mike Tarallo on June 29th at 10:00AM EDT to learn about our new Authoring Experience in Qlik Sense. He’ll show how it expedites layout and chart creation, simplifies filtering, provides easy access to frequently-used properties, and speeds access to data tables and fields. Accelerate application creation for all through simple drag-and-drop actions, lowering the learning curve and increasing data literacy.
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).
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 ea...
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?
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 B...
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.
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 ...
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