Hi,

Is there someone who can help me with following error? The Qlik Server returns this error during the automatic reload of the application. The error does not occur when I reboot the Qlik Server and perform a manual reload.

Thanks in advance

-----------------------------------------

17/09/2019 7:10:31ErrorThe QlikView Server returned a error

17/09/2019 7:10:31ErrorQVS Distribution failed to distribute to QVS

17/09/2019 7:10:31ErrorDistribution to resources failed with errors. Warnings: 0, Errors: 2

17/09/2019 7:10:34ErrorThe task "xx\App.qvw" failed. Exception:

QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.LogBucketErrorException: Distribution to resources failed with errors. Warnings: 0, Errors: 2

   at QDSMain.DistributeTask.RevertOneAndAlwaysOne(Document qvbDocument)

   at QDSMain.DistributeTask.ReleaseQvb(Document qvbDocument)

   at QDSMain.DistributeTask.Distribution(String fileName, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue)

   at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

   --- End of inner exception stack trace ---

   at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

   at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

Hi,

Please see data example below. 

In the current data model these two Fact tables are joined by ProductGroup.

However in a chart it should be presented by all dimensions (Group, ProductName, Color, Size) with correct values per row for StockQuantity and SalesQuantity measures.

Some products doesn't have Color and Size therefore key cannot be combined using these columns.

Existing data model is complex. I am thinking to move Products where available Size and Color in a different Table.

 I am curious whether is possible to create an expression with only Set Analysis (e.g. {<StockColor=P(SalesColor), StockSize=P(SalesSize)>} or something like {<StockColor={"=Only(SalesColor)"}, StockSize={"=Only(SalesSize)"}>} )

It doesn't work properly.

In addition I have created the expression with Pick function where result as expected.

Pick(Match(StockColor,'Green','Red')
// Green
,Pick(Match(StockSize,'40','41')
,Sum({<StockColor={'Green'}, SalesSize={'40'}>}StockQuantity) // 40
,Sum({<StockColor={'Green'}, SalesSize={'41'}>}StockQuantity) // 41
)
// Red
,Pick(Match(StockSize,'40','41')
,Sum({<StockColor={'Red'}, SalesSize={'40'}>}StockQuantity) // 40
,Sum({<StockColor={'Red'}, SalesSize={'41'}>}StockQuantity) // 41
)
)

My question is how to replace Pick function with Set Analysis hence leave only one formula?

Any help will be much appreciated.

Hey guys,

we are using the Dynamics connector to extract data from our Dynamics instance but as Microsoft partner we are forced to enable MFA policy to all our accounts.

If we do this the connection string isn't working anymore (how obvious -.-) and now i am asking is there any workaround?

I thought AppPasswords would do the trick but it's not working as soon as we enable the MFA policy...

We are thankful for any ideas or suggestions 🙂

thanks in advance

Hello folks,

I have sample input data as below

Need output as show in screen shot attached jpg file .  I need to do this using  QlikView script , any help is highly appreciated as I am running under tight deadline of project

Hi All,

I need one help in achieving one result in which i need 13 months rolling with 2 condition.

This is the result which i am getting with this expression.

=pick(match([Prof6 Raw],'ABC'),

Num(sum({<[BI As Of Month]={">=$(=Date(addmonths(Max([BI As Of Month]), -12),'MMM-YY'))<=$(=Date(addmonths(Max([BI As Of Month]), 0),'MMM-YY'))"},Segment={'Auto'},Flag={'Prpop'}>}Value),'###,#00')//
)

Above expression is giving me extra null month columns which i want exclude , not by suppress zero because of chart background formatting. 

Thanks

Hello qlikers,

I found this article: https://support.qlik.com/articles/000041017 . You can find the log files for every application in the QMC.

I want to visualization the log files in Qlik Sense for specific applications. So my question is, how can I read the log files via script for particular applications? 

Thank you in advance. 

I have recently upgrade to Qliksense June 2019.

I want to use the P&L pivot to develop a P&L app.

I have loaded a table into the App that holds all the fields that I want to use in my calculations.

What I want to develop is a P&L that will show the following...

P&L

Heading                                         Current Value

Gross Sales Value                      Sum(T_GSV)   (Where T_GSV is a field from my table)

Invoiced Sales                            Sum(T_INV_SALES)

etc.

Not sure how to load the data or configure the P&L Pivot to get the above result. 

Any help would be greatly appreciated.

Hi All,

We have a requirement where we need to add a Combo chart with two dimensions and Multiple measures  as bar or line graphs respectively.

In QlikSense Out of the box Combo Chart we can only include one Dimension.Need to know if there is any Workaround to achieve this

We have also tried the Combo chart extenison but it did not solve our purpose

Regards,

Bhargav