Hi team,

I am facing one simple error .I dont want to get any space .i need the output should be in 1 line only.I am attaching the  error.

Wrong output:

1.Executive Dashbaord

1.1

Executive Summary.

I need the Output as :

1.Executive Dashbaord

1.1 Executive Summary.

Note:In Backend i am using 

='$(vSheetNameExecutiveSummary)'  as variable which consists  1.1 Executive Summary.(this is just vizlib advanced TEXTBOX)

Hi Experts,

i would like to set login access pass users for infrequent user. However, i saw there are user access allocation and professional user allocation tab in the QMC. could anyone to advise relation ship between theses 2 type and login access pass? and please also advise what i am considering  when creating login access pass rule? i am worried when i creating will affect other thing. 

I have raw data like below...

But I want to keep the latest data only i.e latest record per employee per Dept per YearMonth like below

I want to handle this scenario in QlikView script only as there are many transformation. Here is the sample file with above data. Please suggest.

Test:
Load * INLINE
[Employee, Dept, YearMonth
A , Finance, 201805
A , Insurance, 201808
A , Banking, 201812
B , Finance, 201805
B , Banking, 201803];

@sunny_talwar 

Hello Experts,

I am having one scenario,.

I am using Ad hoc report in Qliksense by using multiple dimensions and multiple expressions.

Base expression is : Sum(sales)/ Sum(Total Sales).

Here if i'm adding region has dimension, Expression should like  - sum(sales)/sum(Total<Region> Sales)

If i included one more dimension , expression should like - sum(sales)/sum(Total<Region,Area>sales)

Means, if i selected any dimension it is going to add or remove from denominator after total qualifier.

Any suggestions ?

Thanks in Advance.

Regards,

Madhu

Hi Experts,

I've meet an issue that I opened the app via mobile application as Rootsadmin and got an error msg "Access id denied".

Before that I didn't change any setting/configuration on QMC or service ports and it works well with no error msg. The only one changed is the version of mobile application. It updated to Sep  2019.

Is it possible the newest version causes the error issue?

Thanks in advance

Dear All,

Recently, we are developing Insight Bot in Qlik Sense.

I have to test the functionalities of Insight Bot.

However, the Insight Bot seems cannot show the trend data.

Anyone can help. Thanks for your help.

Regards,

Leo

Hello all,

I would like to know if it's possible to call an expression (defined in a graph table) in a load statement (edit script) ?

And if it's not, please could tell me if it's possible to combine two expressions in a graph table.

Thank you in advance for your help.

I was working on the heat map and

my first dimension is

day of the week on x-axis

day([patientarrivaldate]) as [arrivalday]

my second dimension is

time of the day on y-axis

hour([arrivaltime])& ':00-' ([arrivaltime]) +1 &':59' as [arrival time]

My aim is to get 00:00 - 00:59, 01:00 - 01:59, 02:00 - 02:59 etc for 24 hours

Measure is no. of patients arrival in the hospital

count(admission number)

any help will be appreciated.

Thanks

Hi Experts,

I have a question regarding the NPrinting environment setup and deployment methods from DEV to PROD.

Currently, we have setup NPrinting in one server and it is used as DEV and PROD. We do not have separate environments for this. However, we have realized this could be a risk if something goes wrong and if NPrinting does not work then there would be no reports sent to my senior managers.

I am trying to understand how is NPrinting usually setup? 

Should I be having separate environments as Development and Production for NPrinting?

If yes, could you please help me guide what is the migration process to migrate a Task, Report etc from Development to Production.

Thanks heaps in advance.

Regards,

Shyam