Hello,

I'm currently putting together employee tenure gantt chart and I've managed to make some progress thanks to the Qlik Community. My current employee tenure chart sorted by joining date order looks like below, but I'd like to use a blue color for male employees and a red color for female employees in order to distinguish and visualize gender in the chart below.  I'd greatly appreciate it if you could let me know how I can do that.  

Thanks a lot for your help!

Hi, I have just started using qliksense and I don't know to proceed with this.

There are data from different countries.

Eg. India:

columns: customerID, Date, Amountspent

customerID for India has a unique prefix 'IN' so it would look like this, IN421445

Malaysia:

columns:columns: customerID, Date, Amountspent

customerID for Malaysia has a unique prefix 'MY' so it would look like this, MY879745

I am required to have data visualization for both within countries and across countries. 

so I need to have a script like this:

Script section A(to load all files AUTOMATICALLY)

if Vcountry='MY'    (Malaysia)

run script B which changes some of the fields and renames everything to MY.field

if Vcountry='India' 

run script B which changes some of the fields and renames everything to India.field

I also don't want to manually copy-paste script B for all the different countries, is there any way to make it repeat automatically?

However I have no idea how to go about doing this, any help would be much appreciated! thank you

Hi everyone.

I have a straight table with columns from the dimensions tab as well as the expressions tab. There is one column at the end (dimension column) that will not move to a different position when I drag it. I played around by adding other dimensions after it and they too refuse to move.

Please help / advise.

Thank you.

Regards,

Ashley.

Hi,

I have remote machine from which I need to open Qlik Sense in chrome.

i get the following error:

I tried to add the external ip from which I connect to virtual host list, but nothing changes.

Can you please help?

Bonjour à tous, 

j'ai un problème de calcule de taux de disponibilité  , ci-dessous l'expression de calcule je pense que le problème est du au format  

I have created a variable for vSort for dynamic Sort Pivot table.

In the variable extension, I use the below formula but when I hit the related button, there is no sorting. I wonder if it is because my formula is wrong.  Hope I could get some guidance.  Many thanks as always.

='fabs(Pick(Match(Movement_Type,"TS1","TS2","TS3","TS4"),sum([S1_GCV_Mov_ HKD000]),sum([S2_GCV_Mov_ HKD000]), sum([S3_GCV_Mov_ HKD000]), sum([POCI_GCV_Mov_ HKD000]))~GCV_Mov|fabs(Pick(Match(Movement_Type,"TS1","TS2","TS3","TS4"),sum([S1_ECL_ Allw_ HKD000]),sum([S2_ECL_ Allw_ HKD000]), sum([S3_ECL_ Allw_ HKD000]), sum([POCI_ECL_ Allw_ HKD000])))~ECL_Mov'

Dear Qlik Family,

I have a question regarding the fliter options in Qlik. I only want to show the possesions in "green". How can I delete the "grey" possesions in this filter?

Thanks in advance!

Robinho

Hi 

Am having the below Problem

I need to show duplicate rows in the data and for that i added rowno but i need to hide the rowno column.

LOAD * INLINE [

rowno, Category, Category_desc

1, A, Cat1

2, B, Cat2

3, C, Cat3

4, D, Cat4
5, D, Cat4

];

I need to show below in the table

A, Cat1

B, Cat2

C, Cat3

D, Cat4

D, Cat4

Thanks in Advance

Hi,

I have an App  (February 2021 version) with many sheets thet show different aggregation of same details Data.
Data of dettail are showed in one sheet. In every sheet I have inserted a button that allows to navigate to details sheet.
I would Like insert a button in the detail sheet to go back to the starter sheet. I have tried to use a Variable that is set in starter sheet, but the solution seems not working.

Do somebody have any suggestions ?

Thanks,

Michele