Welcome to Qlik Community

Hello experts,

I am starting Qlik Sense at a new company and need to convince my colleauges quite quickly. Therefore I need some urgent help on the following issue:

I have uploaded two tables. The first only contains E-Mails from a Blacklist (without any other information). The second table contains Customer information. 

My goal is now to have such a list (first three information from table 2, fourth information derived from table 1). Sounds quite easy but the solutions I have found so far did not work out.

I would be grateful for any help.

Hello,

I have created a line chart. The purpose of this line chart is to show how many calls are made during a period(year, month or week). Wit a script from this forum I have created a master calender and use it as an dimension.

It is working as expected. However when I drill down from month to week I get next to the date of that week also timestamps(see screenshot below). I can not figure out why the timestamps are shown. They are not present in the excel files. Also in de the callender I have used Date format.

I have tried everything to solve this issue with no luck. Can pls someone help me with this issue.

Hello,

my goal is to do the sum of a value field (TIR) ​​only for those dates that are beginning of the month

=sum({<Data{'$(=monthstart(Data))'}>} TIR)

where am i wrong?

Hi Guys,

I need to show the sum of all the dimension values in middle of the pie chart in Qliksense. Is this Possible ?

I need sum total ($275) like below.

Hello guys,

I'm just wondering if this kind of "joints" are a good thing or a bad thing.
Could you help me understanding what's the purpose of these "joints" and if it's a good or a bad thing?

Thank you

I have a [Month ID] as the filter in the chart and wants user to select a particular month. Then in the chart I want to use [Month ID] as the dimension and show the net sales of the last 12 months. As I only select one [Month ID] instead of a range, the chart can only show one month now. Any formula I can use in the dimension value to achieve what I want to do?

RIngo.

Hi Team,

I want to create a flag in QlikView Script, If I select entry_date. Total no. of record in entry_date is 644 and I have selected 401 value. So I need a flag like Y for all those value selected and N means not selected records.

Hope you got my answer. Can any one help me on this.

For data related qvw, I am attaching my qvw.

Regards,
Sona_SA

I have searched many forums looking for an answer to this, but I cannot find one.  We are on Qlik Server (Nov, 2019 I think).  I created an app around 1 year ago that included some calculated numbers in the footer of charts and it displays nicely differentiated with a shaded box like the chart below.

However, I cannot duplicate this same format in any other app.  In all other apps I have created, the footer looks like this, undifferentiated from the main chart and to me much less elegant:

The only other difference I notice is that chart objects are all separated by a small gray bar in the app that differentiates the footer with the gray bar.  

I cannot find any settings anywhere in either app that controls this.  

Thanks,

Jordan

Hello Folks, 
Looking for help. Can you give some insight to provide Top 3 customers by sales plus top 3 customers by product count.

Appreciate your time and help.