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

Hello Everyone,

Recently, i have been trying to implement and following were the Result anticipated:

Expected Result:

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,

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 

I have data in my table where there are some months with zero data and I want to show these months in my bar chart.

I have created the chart and set 'Include Zero Values' in Add-ons -> Data Handling

I am trying to show the number of open tickets using this  expression in the Measure.

if(Status = 'Open',count(distinct {<Status = {'Open'}>}id) + sum({1}1)*0,0)

When no filters are selected my graph shows this:

I have also tired this , which seems better

count({<Status = {'Open'}>}id) + sum({1}1)*0

 (Note Oct 23 is absent)

Can anyone advise?

Thanks

Mark

Hi,

We are currently using  Qlik Sense enterprise on windows May 2023 patch 1 (14.129.7) and are getting "An error occurred. Invalid parameters" messages daily while developing our apps. This is happening to multiple developers on different apps when amending tables and pivot tables e.g. amending existing measures, adding measures

Does anyone have any ideas of why this is happening and how we prevent it? We have looked at the patch 2 release notes and they don't seem to mention a bug fix for this.
It seems to go away when we stop editing and refresh the page but then happens again later in the day

Edit: We now have tables that are unusable. We cannot remove measures from them without getting the error message so are having to create our tables from scratch

Thanks,

Abbie