Hi

Is there any way to limit users to see just their related data without reducing data to too many file?

We are using qlikview dashboards, but as a presentation tool we have another web app which have some links that redirect user to qlikview dashboard.

The problem is :

We have 40 branches and we want any user just be able to see just him/her branch's data, so we established publisher and reduce any dashboard based on its branch.so for any dashboard we will have 41 published ones.

If I want to create links in Total app for any individual dashboard I have to create 41 links (we have 41 branches).I'm looking for a solution which limits access to data without reduction.

Could anybody help me in this case?

Hi

We learned in Qonnection the QlikSense API Endpoints. For example: GET:443/engine/healthcheck, GET:443/qps/user.

We plan to create script that polls the endpoints and reports into datadog. So that we can get easly alerts.

But current we cannot do this because endpoints need authentication. 

Questions are:

1. What is Qlik's recommendation in using API endpoints?

2. How to turn off the endpoints' authentication?

Best regards,

Susan

Hi All,

I have one table as below:

ID      Name

1        A

1       B

1        C

2         D

2          E

3          F

3          G

and I want to show 3 different filter panes for Name based on the ID e.g. filter pane 1 will have data as A B C, 2 will have D  E and 3 will have F G. And I want that these filter conditions should not imapct on each other. Hence I am writing below expressions:

Filter 1: =aggr( Only({1< id={1}>}name),name)

Filter 2: =aggr( Only({1< id={2}>}name),name)

Filter 3: =aggr( Only({1< id={3}>}name),name)

which is showing correct output but when I select filter 1 then fillter 2 values are gray out as in the backend data gets filtered out for ID=1 so there are no records for Id 2 and 3 even though I have  written 1 in expression.

Please note we have older versions on server and Alternate states are not yet available there so any way to resolve this issue.

Thanks in Advance!!

Hi Guys, I'm working on a sales report on qlikview dashboard. I calculate average sales value upto previous month. it's working. But I want to fixed the value in the text box but that's not working. When I choose date or month from the field the average value is changed but I don't want any effect for the average value in the text box. I use a set analysis in the equation. Here is the equation:

=num((Sum({<Month-=,Mday-=,Month-={"$(=vCurrentMonth)"},Year={"$(=vCurrentYear)"}>}Gross_Value)/
(count(distinct {<Month-=,Mday-=>} Month)-1))/1000000,'###0.0')

where, vCurrentMonth=2019

Please help me ASAP, Thanks.

Hi Team,

We are facing a issue of junk value getting populated in derived fields. But if reload the same data model multiple times this issue gets rectify. Kindly any one suggest the remedy.

Regards,

GR

Hi, 

I've been working with Qlik View for two weeks. 

I will like to show all the values of a line chart, like show all the series (Excel) or series group (SQL Report Builder), not the sum of all of them.

The image shows two list box, the one of the left shows the values related to the list box of the right. The Line chart shows the sum of the values of the list box of the left, It doesn't show each value individually (two lines on this example). How can I do that? 

Thanks in advance for your help.

Best regards, 

Francisco

Hey guys,

Its possible to create a combined bar/line chart like this?

Dec/17 =  2017 accumulated

Dec/18 =  2018 accumulated

1T19 = First 2019 trimester accumulated

and next months.

Tks guys!!!