Recent Discussions
-
Upload file to qlik cloud in specific space
Hello, i'm trying to upload a parquet file from talend studio into qlik cloud using the tQlikOuput component, i've succeded to upload it into my perso... Show MoreHello, i'm trying to upload a parquet file from talend studio into qlik cloud using the tQlikOuput component, i've succeded to upload it into my personal space, but i need to use a different space, does anyone can give me any suggestion on how to achieve it if possible?
Thanks, in advance,Vincenzo.
-
BookMark selection only to specific sheet
Hi,I have a requirement in Qlik sense that i have 3 sheets in a app and in the third sheet I need to set max month as default selections and sheet1and... Show MoreHi,
I have a requirement in Qlik sense that i have 3 sheets in a app and in the third sheet I need to set max month as default selections and sheet1and sheet2 should not be affected based on this selections applied on the 3rd sheet.
Any suggestions would be highly appreciated on this regard.
Regards,Raju -
FIlter in set analysis doesnt working function LEN
I´ve a table with 8865 rows where DT_INCLUSAO is null But in count if i use = COUNT({<DT_INCLUSAO = {"=Len(DT_INCLUSAO)=0"}>} ID_TRABALHADOR) return... Show MoreI´ve a table with
8865 rows where DT_INCLUSAO is null
But in count if i use = COUNT({<DT_INCLUSAO = {"=Len(DT_INCLUSAO)=0"}>} ID_TRABALHADOR)
returns no rows
I tryied:
COUNT({<DT_INCLUSAO = {"=Len(DT_INCLUSAO)=0"}>} ID_TRABALHADOR)
COUNT({<DT_INCLUSAO -= {"*"}>} ID_TRABALHADOR)
COUNT({<DT_INCLUSAO = {"=IsNull(DT_INCLUSAO )"}>} ID_TRABALHADOR)
COUNT({<DT_INCLUSAO = {"=Null()"}>} ID_TRABALHADOR)
COUNT({<DT_INCLUSAO = {"='null'"}>} ID_TRABALHADOR)
COUNT({<DT_INCLUSAO = {"=IsNull(DT_INCLUSAO ) or DT_INCLUSAO =''"}}>} ID_TRABALHADOR)
unsuccessfull 🥲
-
currency conversion AUD to USD not working in Qlik Sense
Hi Team,I have multiple company currencies to convert into .all currencies working but the issue is with AUD and New Zealand currency translations.ple... Show MoreHi Team,
I have multiple company currencies to convert into .
all currencies working but the issue is with AUD and New Zealand currency translations.
please help to fix this issue.
Sum([Account_Receivable_Evolution.Amount_$(vCurrency)])
$(vCurrency) = USD -
API Creation
Dear Sir/MadamKindly advise how to create an API for Qlikview version 10 Applications?.Many Thanks, Tracy -
show all Subfield values in table chart visualization
i have a column "TDays" with data "21;15;29;5;6"when i put function subfield(TDays,';') it get display the first values from the subfield . Can we ge... Show Morei have a column "TDays" with data "21;15;29;5;6"
when i put function subfield(TDays,';') it get display the first values from the subfield .
Can we get all the subfield split data into the table?? as shown below
Subfield
-
Tableau to Qlik
Was wondering if anyone can share their experience transitioning from Tableau to Qlik. I have over 3 years experience using Tableau and a new prospect... Show MoreWas wondering if anyone can share their experience transitioning from Tableau to Qlik. I have over 3 years experience using Tableau and a new prospective employer solely uses Qlik instead. I don’t have any issues learning new software but I want to know how big the learning curve is moving from one to the other.
-
Link Customer to Pricelist
Good morning. I'm sitting with a scenario where I need to show the Price of Items per Customer, based on their Pricelist number. There are 5 pricelist... Show MoreGood morning.
I'm sitting with a scenario where I need to show the Price of Items per Customer, based on their Pricelist number. There are 5 pricelists available, numbers 1 to 5. On the Item side there are 5 pricelists fields, PL1 to PL5. There is no common field between the tables for association. The attached snippet shows it better.The fields in the two tables are.
Item:
SQL SELECT
ItemCode,
PL1,
PL2,
PL3,
PL4,
PL5
FROM Items;Customer:
SQL SELECT
CustomerCode,
"Price List"
FROM Customer;I really appreciate any thoughts on how this can be done and if it actually even possible. I include a simplefied version of the model and spreadsheet. In reality there are about 14000 Customers and 9000 Items
Thank you in advance. -
Best method to create a new conditional field using Data flow
Hello Qlik community I am hoping to use Data flow to create a new field to capture "New Customers" as a column. For example , I would like to be able ... Show MoreHello Qlik community
I am hoping to use Data flow to create a new field to capture "New Customers" as a column.
For example , I would like to be able to filter customers who have only purchased products from the last 3 months or only this year 2025 as "new customers", and the rest as "previous customers".
How might I design this new field using processors via Data flow (as I am joining this table with other datasets as well)?
I've tried aggregation, but it seems I unable to restrict dates and sales. Is there a non-script way to go about this?
Thank you!