Hi guys,

I have connected to Outlook and there is a dimension called: =[EventsForCalendar.attendees]. this shows the attendees with their emails. The structure in this dataset is like this: surname.name@outllok.com,surname.name@outllok.com, surname.name@outllok.com. My colleague wants the emails to be processed like this: last_name.name, last_name.name, last_name.name. I have tried this: =SubField(SubField([EventsForCalendar.attendees], ',', 1), '@', 1), but then the other names in the line are not displayed anymore and it always varies and turns out to be more complicated than expected, if anyone has any ideas, I would be very grateful.

We were doing various tool evaluations for building MDM, DWH and Analytics platforms. At that time we found that Qlik Sense is a better visualization tool than Power BI and our company has already acquired multi-user licenses to use the tool. Qlik is also a premier product and has more features as Data Visualization tool. Therefore I would suggest you to start the further analysis and report building process using Qlik Sense. For any further support on Qlik, you can approach the IT department.

Hi Experts,

The excel is my source and it has millions of records, wherein I need to split the multiple string values (wrapped text) into the next individual rows not columns. I tried subfield with a space as delimiter, but I didn't get the required output. Doing it in excel is a manual work even using the function as Textsplit(A2,,char(10))

Going ahead with the Textsplit function in excel I need to make sure that there are empty rows beneath the row from where I need to extract the individual values to the next row and all this while I have been manually inserting the rows.

Is there a way to do it on Qlik Sense which would resolve the manual effort. Some rows have single string value which is fine, only the cases where multiple values are wrapped.

my data looks like this:

The desired output is to be:

Also, I need to extract the file extension (.xls, .xlsx, .pdf, .msg, .tif) in a different column for all the evidence once these are splitted into different rows. Taking the right substring function is not helping as there is no uniformity in the extensions as they are xlsx or xls and so on. Any help is appreciated.

Good day Qlik Community,

It's me again (not Mario, but Igor). Contrary to what my initials say (Alcantara, Igor) I am not an AI but I do like AI. If you read my previous articles in Data Voyagers(BLOG | Data Voyagers), you know that I writing about my experience with Qlik Answers. This is another one of those.

In theory, and that is what I have being telling customers, Qlik Answers only works with unstructured data. However, the 2nd most common question I answer is "can Qlik Answers reads structured data like Excel or CSV?"(the first is: "Can I export to Excel?").

Well, this time I decided to test it and to explore how I could make the impossible, possible.

It is all here. I hope you all enjoy it. If so, please like it and share it.

Can we make Qlik Answers talk to Excel? (datavoyagers.net)

i have been working on this project for months now and after i finalized most of the data warehouse my client noticed that all names that have Arabic letters shows as "???? ???" and when i was investigating the issue i found out that nvarchar is not supported in compose. is there a way that i can show the Arabic names? 

Hi Team,

Have an alert setup in QlikView Desktop, but recently not work, the setup is:

1 - Condition

2 - Events is On Post Reload

3 - Trigger Level is Message Changes:

4 - Mode, not have anything (is right?)

5 - Message is dynamic

6 - Mail Subject is plain text

7- Mail Recipients have various email and is a semi-colon separated 

I validated the setup Mail server on QMC and the test mail is functional, but the alerts not work.

Thanks for your help!!

I am using the below formula in a pivot table (I use two dimensions MATERIAL and GERENCIA):

sum({
<FECHA= {">=$(=Date(MonthStart(Max(FECHA)), 'DD/MM/YYYY'))<=$(=Date(Max(FECHA), 'DD/MM/YYYY'))"}>
} SALES) /
sum({
<FECHA= {">=$(=Date(MonthStart(Max(FECHA)), 'DD/MM/YYYY'))<=$(=Date(Max(FECHA), 'DD/MM/YYYY'))"}>
} Aggr([Días],FECHA,MATERIAL,GERENCIA)) *
Max(Aggr(If(FECHA= Max(total FECHA), TotalDías),FECHA,MATERIAL,GERENCIA))

This formula works correctly if a remove of the pivot table one of the two dimensions and if I remove of the formula the dimensions I am not using, but the problem is when I use both dimensions the calculation goes wrong, because if I put firstly GERENCIA and the MATERIAL as dimensions the results of the MATERIAL are correct but for GERENCIA is wrong, specifically I have two values in MATERIAL and for any reason I don´t understand the total value of GERENCIA is divided for two (two distinct values of MATERIAL field) and if I use first MATERIAL and then GERENCIA  the values of GERENCIA are calculated correctly but the total value for MATERIAL are divided for the distinct values I have in the GERENCIA field, in this case MATERIAL is divided in 8, but if the first dimension used in the pivot table is not divided for the distinct values of the second dimension the value of the first dimension would be calculated correctly.

So, I appreciate if any of you have any idea to resolve this problem using aggr function with more then one dimension in a pivot table.

Thanks.

It's been a long time since users and devs are asking qlik to change the object pivot tables. it most certainly is the one object that everyone needs on its analitycs app but qlik seems to don't care about its usability and flexibility. As a result, qlik offers one of (if not the most) worse pivot table object of the industry. And seems to be OK with it. 

In one shy movement that may be seen as an attempt to close this gap, the visualization bundle pivot table was released but, it still has some issues that are hard to live with...

As example, I post a print of the same data on the two objects. the upper is the old pivot table, unusable. below is the visualization bundle pivot table with the annoying divisor between dimensions and measures that simply can not be moved to an optimum fit... 

come on qlik. give IA break and fix the basics.

Hello Qlik Community,

I can't seem to get the RangeAvg(Above working in a line chart, it is reporting lower numbers than expected and what is reported in a straight table.  No problem using the RangeAvg(Above in a straight table.

The variable vMeasureSelector3 is made up of numerous master measures, one example is "OFD" which is this expression: Num(Count(if(StopTypeCode='D', StopNum)), '#,##0')

Here is the expression:

IF(
vAggregationType = 'Daily',
[$(vMeasureSelector3)],
IF(
vAggregationType = 'Rolling Average - 7',
RangeAvg(
Above([$(vMeasureSelector3)], 0, 7)
)
)
)

Thanks/Mike