Recent Discussions
-
If statement with date
Hi I have a text box that contains the following if statement =if (DATE(TODAY() - MOD(WEEKDAY(TODAY()) + 2, 7) - 1, 'DD/MM/YYYY') = DATE(MAX(FLOOR([JO... Show MoreHi I have a text box that contains the following if statement
=if (DATE(TODAY() - MOD(WEEKDAY(TODAY()) + 2, 7) - 1, 'DD/MM/YYYY') = DATE(MAX(FLOOR([JOB_DATE])), 'DD/MM/YYYY'), '', 'ALERT *Missing Fridays Data for jobs')which was supposed to warn for missing data on a friday. but this only works the following day because the max wont be that day so i tried to do it with a count
=IF(Count({<JOB_DATE = {"$(=DATE(TODAY() - MOD(WEEKDAY(TODAY()) + 2, 7) - 1))"}>} JOB_DATE) > 0, '', 'ALERT *Missing Fridays Data for jobs')
this didnt work because JOB_DATE contains date and time.
but floor doesnt work in the count so this doesnt work at all 😞=IF(Count({<Date(Floor(JOB_DATE), 'DD/MM/YYYY') = {"$(=DATE(TODAY() - MOD(WEEKDAY(TODAY()) + 2, 7) - 1))"}>} JOB_DATE) > 0, '', 'ALERT *Missing Fridays Data for jobs')
does anyone have an idea how to fix this? seems simple but i have run out of solutions
-
AWS KMS Encryption Decryption in talend
Hi, I have a use case where we are receiving the AWS KMS encrypted file in s3 and this file i have to decrypt in talend for data load. Has any one eve... Show MoreHi, I have a use case where we are receiving the AWS KMS encrypted file in s3 and this file i have to decrypt in talend for data load. Has any one ever worked around it ?
Thanks
-
How to aggregate superposed areas in a single area while conserving their inters...
Hello,I need to add a new layer to a map made of the aggregation of multiple areas.The areas are based on a radius of 40km of multiple coordinates (th... Show MoreHello,
I need to add a new layer to a map made of the aggregation of multiple areas.
The areas are based on a radius of 40km of multiple coordinates (the coordinates are the location of some customers), which I was able to generate for each customer using qlik script. (see below)
I tried to use the GeoAggrGeometry() function to create the new polygon aggregating all areas, however it seems that the function cancels out any intersection between areas. Since I have customers that are very close to each other, I can't get a map with a full single merged area.(see below)
Does anyone know if there's a workaround this issue or another way to get the expected result?
Thanks in advance for any information that may help!
-
read app tags in Qlik Cloud
I would like an Qlik Application Automation to read the tags that are saved at app level. Is there a way to do that? See example below: Show MoreI would like an Qlik Application Automation to read the tags that are saved at app level. Is there a way to do that?
See example below:
-
Label and data value together in a pie chart
Hi All, I have a donut chart and the labels are male and female. Now the data values are coming inside the donut chart and the labels are outside th... Show MoreHi All,
I have a donut chart and the labels are male and female. Now the data values are coming inside the donut chart and the labels are outside the donut chart. Is there any way i can put data values under the label. So i am looking for Female(22.11K) and Male(37.47K)
Thanks
-
Help with stacked bar chart
I have a dataset with a column called Products with five types of products, from which I only need to represent three in a stacked bar chart. (Those p... Show MoreI have a dataset with a column called Products with five types of products, from which I only need to represent three in a stacked bar chart. (Those products are shirts, shoes and dresses)
I also have five columns Q1,Q2,Q3 , Q4 and total yearly
The stacked bar chart should have in the x axis the Q1, Q2, Q3 Q4 and total yearly, and in the barst the three types of clothing should be represented.
As far as I know, I need to pivot or unpivot those three columns? Something related to taking the resident table?
I am a little lost and i would appreciate any help..
attached u will find a pic of what i need, the quality of the drawing is not good, but i guess u get the idea 🙂
thanks
-
How to make a horizontal excel type table
Hello, Looking for ideas on how to make a table look similar to this where it's more landscape based... -
Incremental Load using where clause
Suppose I have a employee data. First I generate the QVD's. When i start to perform incremental load on QVD's using API's so i want only change data a... Show MoreSuppose I have a employee data. First I generate the QVD's. When i start to perform incremental load on QVD's using API's so i want only change data add in the QVD based on employee ID.
How to solve this problem? -
Qlik sense Automation
Hi, I couldn't send mail by generating the report of an app to pdf. It shows the following error. How to rectify it? error: json_encode error: Malfo... Show MoreHi, I couldn't send mail by generating the report of an app to pdf. It shows the following error. How to rectify it?
error:json_encode error: Malformed UTF-8 characters, possibly incorrectly encoded -
SimpleFieldSelect Extension scrollbar freezes on clearing the selection
Hello Team, We have one extension object(SimpleFieldSelect) used in our dashboard where we have scroll in our report sheet/Page when ever we clear the... Show MoreHello Team,
We have one extension object(SimpleFieldSelect) used in our dashboard where we have scroll in our report sheet/Page when ever we clear the filter selection from this field selection from dropdown.We have already used in our existing dashboard but as per old requirement we did not have any scroll in our report. now as per new UI we have many options and user selection due to that we have scroll in our landing page .I have observed that if we clear selection from "Simple Field Select" extension scroll bar freezes , get stuck and it does not allow to scroll down or up UI get freeze at the same state.
Please provide solutions if someone faced similar issue.