Hi,

We have a same dashboard present on Server A to Server B.

We observed that the performance of the dashboard on Server B is slower than that of Server A.

If the dashboards present on both the servers are exact same in design, data and memory.

What are the others factors that are affecting the performance.

What all factors should we compare on both the servers to figure out why the performance is slow on Server B.

Kindly guide.

Hi,

I have a requirement where i need to get the nth ranked value for a dimension, sample table given below

The Column Threshold value is what I want to compute.

So we are looking at a range of dates for the customers and the indicator is computed on some logic.

The Threshold value is based on the value in the indicator column. It is the nth rank value for each customer where n is the value in the indicator column.

I have tried to use Firstsortedvalue and Max , but both need a number or a variable in the rank agreement. I want to use the indicator column.

Formula i used :

FirstSortedValue(Value,-Value,indicator) - gives wrong result

Max(Value,indicator) -  gives wrong result

I cannot give a fixed number in the last agreement of both the functions as it changes with customer. Please advise if any solution for this scenario.

Hello,

I have data for vehicle registration and Movement count. I want to group these not by serial but by count.

e.g.  "16" movement count - 2 vehicles , 2% of all movements

Thanks

HN51 CWM	17
GL52 XOO	16
OJ69 BVU	16
GS57 IGF	15
UX69 UMP	15
CM58 HNQ	15
PA66 BSA	13
RC63 IFF	13
LT61 TTK	13
KN57 GNM	13
QP68 ZVX	13
MI61 VJY	13
JX65 RKR	12
IT52 TZL	12
HV61 EDP	12
LS69 BBP	12
IU52 NAK	12
QV63 QYJ	12
CO67 UNO	12
BO58 HGZ	12
TN59 ZPF	12
TE53 SJV	11
TA69 VME	11
HY52 PIQ	11
WY69 OCK	11
DO63 PRF	11
EU64 IBZ	11
DF53 QNT	11
NC64 MUY	11
AU61 LAP	11
LF55 OFF	11
FM59 MIE	11
XR67 KPE	11
OA68 YZL	11
KS67 PMK	11
XU67 BGD	10
MM66 BRN	10
BJ65 IKA	10
EN61 TKZ	10
KZ67 WWW	10
QO56 RGF	10
FP65 XNX	10
IO67 MIF	10
LY66 IXU	10
IE52 PPF	10
CW62 VFU	10
CS64 JBX	10
TP63 IJU	10
JF66 VAI	10
YC63 IAJ	10
JV57 ENE	10
VQ59 QEG	10
FC67 VNJ	10
AI59 OXR	10
MU53 BER	10
HK62 ZNX	10
TF66 VPB	10
YN69 ONF	10
ET67 CTQ	10
EM55 ADB	10
JR62 ZMN	10
SG67 JUF	10
AY52 PJP	10
YI67 SSD	10
QX66 VZB	10
LG61 YVH	10
UJ62 FEF	10
SR61 IGU	10
IK66 ZOO	10
VY51 APV	10
CJ57 VHH	10
GY68 RLR	10
DY59 OBI	10
AH56 HTY	10
CU56 PVL	10
IG54 CAV	10
JK63 DRH	10
EL61 HMK	10
ID62 UOF	9
JK52 RLD	9
MR51 FAE	9
MK58 PFK	9
YK62 YAX	9
PJ67 NCN	9
OQ64 GGN	9
HH58 ZHK	9
FL61 NFX	9
AP53 XLK	9
PC61 VRM	9
JO55 YJD	9
ST53 XRN	9
AF53 GYI	9
BQ56 BZF	9
YC62 HMJ	9
TQ53 ZZV	9
NQ54 MXL	9
CJ62 MIL	9
LC51 XRD	9
GY63 UGO	9
GK53 SIL	9
OT56 KDH	9
KA53 SKT	9
YJ59 CXB	9
AG67 AKP	9
VE58 KOX	9
NN54 DRZ	9
AO67 QZL	9
VK56 SBM	9

hi,

I have problem in which the data is containing customer, month, year and sales and I will provide the data set below.I need the output as mentioned in the data set (sheet 2) please look into it ad provide me the solution.

Thanking You in advance,

Is it possible to hide buttons (macros that launch Excel files mainly) that I as a developer use to access certain databases and mapping tables (mainly Excel files) from users using Qlikview via the plugin?

I want to extract month number from name in expression(measure).

for example if month name is March it should return me 3. Kindly suggest me a function for that in qliksense.

I have the ListBox to select or enter some number in user input box .
Based on the selection value from my ListBox or Input Box value, my count automatically should change automatically.
For Example,
if i select one number from my ListBox(ListBox Name : SeqDays) , then my count should get change automatically.

What i have done so for as mentioned below steps

1. I created one variable and assign those variable to "SeqDays" ListBox.
      vUserInput =GetFieldSelections(SeqDays) ==> // ListBox values assigned to vUserInput variable

2. I have applied for one expression in a PIE CHART (i.e) ==> < 5 Days (Expression).
     below is my expression.
     =Count({<NewDate={">=$(vCalDate)<=$(vToday) + $(vUserInput)"}>} NewDate)

3. My other variables

     vCalDate=date(vToday-5,'DD-MM-YYYY')

     vToday=date(Today(),'DD-MM-YYYY')

My Requirement is,

I just want to add listbox value "vUserInput" into my date condition expression (>=$(vCalDate)<=$(vToday) )in to the condition.
I tried many ways. but, no way to track and get the userinput values. It is not working. count will not be changing based on my "SeqDays" selection.

What might be the problem.?????

pls. find attached sample file with condition i used...

Note : I tried to solve this issue for long time. but, not getting proper solution.

Hi,

We have Qlikview 12.20 installed on our machines.

When we open a dashboard, originally developed in Qlikview 11.20, in the Qlikview 12.20, then the sort order in the pivot tables is breaking.

Is this a known behavior of Qlikview, that when a document developed in 11.20, opened in 12.20, the sort order in pivot table breaks?

kindly clarify.