Hello Qlik community,
I need a field where I can see when a user last used Qlik. Is this field included in my data model or do I need to calculate it myself?

Hi, I am new to qlik,
I have a pivot table with the dimensions group and subgroup.
the group field is a concatenation of group number and the group name (Num_Group & '- '& Group) and the Subgroup field has the same logic
( (Num_Subgroup & '- '& Subgroup)).
The problem is that I get a null concatenation in the filter panel.
in my dimension I was putting this expression: if(isnull(Group_concat or Group_concat='-'), Group_concat), but it still doesn't remove the null concatenation from the filter...
Can you help me, please.

Hi , I would like to know if it is possible to have intersection without using P()  .

I used the below calculations and does not give me correct results.

1) Count({<ID=p({<year={'2022'}>})>*p({<year={'2023'}>})>}distinct ID) 

this calculation bumps up numbers since the individual P() also does that.

2) Count({<year={'2022'},ID=P({<year={'2023'}>}ID)>}distinct ID) 

This calculation from other post is working to some extent but here and there bumps up the numbers a little and I saw P() adds up extra ID's in the count .

So I have Count({<year={'2022'}>}distinct ID) and Count({<year={'2023'}>}distinct ID) , which fetch me correct results , is it possible to have a intersection between them?

Thank you!!

Hi Qlik Community

I'm having some troubles with conditional coloring.

I have a line graph like below with 2 measures. It is the 2 measures in %. 

I need to color each line with a distinct color code and not the default values.

I'm using the color by expression but cant get the desired outcome. I have a flag that should control the color.

When flag_field = 1, color 1 and when flag_field = 0, color 2 should be applied.

Any help is appreciated.

Hi All,

I am trying to get some data out of an database. However, the load script does give an error in Qlik. When I run the SQL statement in the database, there occurs no error.

See below the error and the SQL statement.

Select
a.FK_BUDGETORDERINTAKEYEAR,
a.BUDGET,
a.MARGE,
a.BUDGETPRODUCTION,
a.PK_U_BUDGETORDERCATEGORY,
a.FK_BUDGETORDERCATEGORY,
a.FK_BUDGETSERVICECONTRACTTYPE,
a.INVOICEORDERINTAKE,
b.PK_R_ORDER,
b.FK_ORDERCATEGORY,
c.PK_R_SALESORDERDETAILMISC,
c.NETSALESAMOUNT,
c.ORDERDATE,
//c.FK_SALESPERSON,
d.FK_FINANCIALYEAR,
d.PRODUCTIONPERCENTAGE

FROM U_BUDGETORDERCATEGORY a
LEFT JOIN R_ORDER b ON a.FK_BUDGETORDERCATEGORY = b.FK_ORDERCATEGORY
LEFT JOIN V_R_SALESORDERDETAILMISC c ON b.PK_R_ORDER = c.FK_ORDER
LEFT JOIN U_PRODUCTION d ON c.PK_R_SALESORDERDETAILMISC = d.FK_SALESORDERDETAILMISC;

I have a chart with a time-variable on the horizontal axis which is loaded from the a time/date table (which is loaded independent of any data). I want the horizontal axis show all the values within the time range but the chart is not showing one period because there is no data. Instead of showing a gap, It just ignores this timepoint.

Why, and how can it be corrected? I have enabled "show null-values". As mentioned: the timetable is completely loaded, no period is missing.

Hi all,

Please, can anyone explain or send me a link that explain step by step on how to us VB Script Macros to Send email through Outlook In QlikView?

Thanks 

Hello everyone,

We have 2 QlikSense servers in our internal infrastructure and we want to expose these 2 servers externally, through Nginx.
We would like to be able to access these servers via ourdomain.com/qliksense1 and ourdomain.com/qliksense2.
Is it possible to configure Nginx to allow this?

Furthermore, we also require virtual proxies for some of our custom apps and we would like to be able to access the virtual proxy via ourdomain.com/qliksense1/virtualproxy and ourdomain.com/qliksense2/virtualproxy.
Is this possible?

Thank you!