Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Recently, i have been trying to implement and following were the Result anticipated:
Expected Result:
GSKG Artikel | |
60 82xx xxxx xxx | 103002 |
60 84xx xxxx xxx | 103002 |
60 90xx xxxx xxx | 103002 |
60 8700 0001 001 | 103002 |
60 8900 0082 001 | 103002 |
60 8900 0082 002 | 103002 |
60 8900 0082 003 | 103002 |
60 8900 0082 004 | 103002 |
GSKG all Artikel | 103001 |
The query that i wrote was:
if((Left(KeepChar(GSKG_Zufu_Artnum,'0123456789'),1)=6082 and Left(KeepChar(GSKG_Zufu_Artnum,'0123456789'),1)=6084
and Left(KeepChar(GSKG_Zufu_Artnum,'0123456789'),1) =6090 and If(WildMatch(GSKG_Zufu_Artnum,6087000001001),103002,If(WildMatch(GSKG_Zufu_Artnum,6089000082001),
If(WildMatch(GSKG_Zufu_Artnum,6089000082002),103002,If(WildMatch(GSKG_Zufu_Artnum,6089000082003),103002,
If(WildMatch(GSKG_Zufu_Artnum,6089000082004),103002,Text(103001))))))) as Zufu_WeBuDaten_Leer_E1MARCM_PRCTR,
While loading the Data, it fetches an Error in these lines.
Could anyone please go through once my query and Required Result and suggest me or clarify me the mistake i am making?
Thanks in advance.
Hi team,
I have a doubt regarding creating filter conditions for a column, in the attached image I have used two filter condition, I'm having a requirement were I want to use more number of filters that maybe in thousands(using python API QEM) , is it possible or can I know whats the maximum number of filters I can use.
Thankyou
Regards
Sreehari
Hi,
While opening a Qlik Cloud app on mobile, the legends of charts disappear while viewing the chart on portrait mode. If I rotate the mobile in landscape mode, the legends appear again.
I understand that because of Qlik's responsiveness, it automatically adjusts objects to screen resolution and hides some items for better adaptiveness. However, I just wanted to know if there's any workaround that will help us show the legends even in the portrait mode, without losing the responsiveness and adaptability to different screen resolutions.
Regards,
Bhaskar.
Hello,
I have this load script for one of my app in Qliksense.
Table1:
Load
First_Name,
Last_Name,
Salary,
Fiscal_Year
SQL Select
FirstName as First_Name,
LastName as Last_Name,
Salary,
FY as Fiscal_Year
From XYZ_Table
In the sheet, I have this simple table with Fiscal_Year column that shows all the data for all the years.
User requested to filter the data to only shows the current year and two previous years. I have adjusted my code to this:
Table1:
Load
First_Name,
Last_Name,
Salary,
Fiscal_Year
SQL Select
FirstName as First_Name,
LasrName as Last_Name,
Salary,
FY as Fiscal_Year
From XYZ_Table
WHERE Fiscal_Year >= (YEAR(GETDATE())-2); //to get only year 2024 and 2023,2022//
It loaded successfully and I got no errors, but when I go to my table in the sheet, I still see years from 2016-2021
I am not sure what I am missing. Could someone please help me with this?
thank you!
Hey everyone,
I have recently developed a dashboard using the new layout container object. I have several other objects like the Pivot table, and straight table inside the layout container. I see that the Full-screen option for any of the viz inside layout containers is not working.
Firstly, there is no icon on the top right to open viz in full-screen mode. Secondly, if we try to right-click on the object and then click on full screen, the full screen does not work on the complete layout gets unaligned.
Has anyone faced this issue? Is there any workaround for this?
Thanks and looking forward for your responses.
Thanks,
Piyush
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!