Home | Qlik Community

New to QlikView

autonumber for client id x order id

Hello,i have a huge database or customer id, order id and value of order.i want to add a new column (the 4th one), like a flag, which counts the numbe... Show More

Hello,
i have a huge database or customer id, order id and value of order.
i want to add a new column (the 4th one), like a flag, which counts the number of the order for each customer.
for ex:
if customer A has 2 orders (#145 and #267) and customer B has 3 orders (#189 #211 and #214), the final table will be this one:
customer order id flag order
A 145 1
A 267 2
B 211 2
B 214 3
B 189 1
this will work also as a dimension, if selecting 1, i will have all the first order for all customers.

thanks a lot,
Andrei

Show Less

By andreip21 2020-02-23 / 07:41 AM

2 Replies 0 Likes
New to Qlik Sense

Count Average of Agents per Day

Hi!I'm trying to count the average distinct agents per day in a call center.* On Day 1 - there are 5 agents (A,B,C,D,E) who answered 20 calls* On Day... Show More

Hi!
I'm trying to count the average distinct agents per day in a call center.
* On Day 1 - there are 5 agents (A,B,C,D,E) who answered 20 calls
* On Day 2 there are 5 agents (A,B,C,D,F) who answered 20 calls
For a single day I counted the distinct agents (otherwise the count will return 20) but when I want to do an average between more then 1 day - that's when I'm confused - (the correct result I'm expecting is 5)
Selecting the two dates in the filter - results in 6 agents so not correct.
I'm looking to somehow aggregate the distinct count per day and then dividing by distinct dates.
Would appreciate any assistance! - Thanks!
Show Less

By MichalSa 2020-02-23 / 04:15 AM

1 Reply 0 Likes

Qlik Sense App Development

Crosstable to generate date while loading data in qlik

Hi Team,I have the below data set :-VLS Global ... Show More

Hi Team,

I have the below data set :-

VLS Global

Customers	April-19	May-19	June-19	July-19	August-19	September-19	October-19	November-19	December-19	January-20	February-20	March-20
NOK parts in customer database - total	Real NOK parts manufactured - total	Number of official Written concern	Total number Alert + Unofficial Written concern	Volumes shipped (external sales only)	NOK parts in customer database - total	Real NOK parts manufactured - total	Number of official Written concern	Total number Alert + Written concern	Volumes shipped (external sales only)	NOK parts in customer database - total	Real NOK parts manufactured - total	Number of official Written concern	Total number Alert + Written concern	Volumes shipped (external sales only)	NOK parts in customer database - total	Real NOK parts manufactured - total	Number of official Written concern	Total number Alert + Written concern	Volumes shipped (external sales only)	NOK parts in customer database - total	Real NOK parts manufactured - total	Number of official Written concern	Total number Alert + Written concern	Volumes shipped (external sales only)	NOK parts in customer database - total	Real NOK parts manufactured - total	Number of official Written concern	Total number Alert + Written concern	Volumes shipped (external sales only)	NOK parts in customer database - total	Real NOK parts manufactured - total	Number of official Written concern	Total number Alert + Written concern	Volumes shipped (external sales only)	NOK parts in customer database - total	Real NOK parts manufactured - total	Number of official Written concern	Total number Alert + Written concern	Volumes shipped (external sales only)	NOK parts in customer database - total	Real NOK parts manufactured - total	Number of official Written concern	Total number Alert + Written concern	Volumes shipped (external sales only)	NOK parts in customer database - total	Real NOK parts manufactured - total	Number of official Written concern	Total number Alert + Written concern	Volumes shipped (external sales only)	NOK parts in customer database - total	Real NOK parts manufactured - total	Number of official Written concern	Total number Alert + Written concern	Volumes shipped (external sales only)	NOK parts in customer database - total	Real NOK parts manufactured - total	Number of official Written concern	Total number Alert + Written concern	Volumes shipped (external sales only)
Brazil	3	34	1	3	9,780	0	0	0	1	18,540	0	0	0	1	14,940	0	1	0	1	16,080	360	360	1	1	17,550	0	0	0	1	14,400	0	0	0	0	13,560	0	0	0	0	15,150	0	0	0	0	6,720	0	0	0	1	15,722	0	0	0	0	0	0	0	0	0	0
Bulgaria	0	0	2	2	66,300	0	0	0	0	66,247	0	0	1	1	58,524	2	2	2	2	31,413	0	0	0	0	42,678	0	0	0	0	55,928	0	0	0	0	56,031	0	0	0	0	67,833	1	3	1	1	32,529	92	192	3	3	1,21,395	0	0	0	0	0	0	0	0	0	0
India Pune	4	482	3	3	78,220	2	477	2	2	81,296	6	291	4	4	75,567	4	230	2	2	76,701	4	188	2	2	64,348	5	155	3	4	66,408	2	304	1	1	66,055	2	594	1	1	67,963	6	553	2	2	79,107	12	1,149	3	3	1,29,007	0	0	0	0	0	0	0	0	0	0
Italy	22	25	22	25	90,727	266	266	8	8	1,60,454	99	99	8	8	1,29,181	94	94	3	3	1,22,702	0	12	0	5	48,759	9	65	3	10	1,57,680	14	54	5	14	1,06,100	1	60	1	5	90,640	0	1	0	1	66,798	0	79	1	4	1,89,860	0	0	0	0	0	0	0	0	0	0
Mexico	60	1,991	2	9	3,98,365	6	1,216	5	18	5,03,689	6	956	2	11	4,41,184	2	875	2	9	3,97,019	1	398	1	19	3,82,425	2	217	0	15	4,08,460	26	355	6	18	4,26,588	1	255	1	9	4,04,869	2	151	2	8	3,12,553	12	152	2	5	3,52,511	0	0	0	0	0	0	0	0	0	0
Morocco	0	95	0	0	25,468	0	68	0	0	32,506	2	34	0	2	49,553	1	55	1	1	59,620	0	9	0	0	28,168	0	185	0	0	45,733	4	70	4	4	68,125	0	42	0	0	53,343	7	94	2	2	56,074	0	40	0	0	81,483	0	0	0	0	0	0	0	0	0	0
Novy Jicin	27	481	15	34	9,33,556	21	988	21	53	10,17,364	13	635	10	37	8,49,793	12	1,008	7	59	6,40,068	13	456	6	17	6,28,021	8	795	8	30	9,51,843	8	677	7	41	9,57,245	7	1,261	7	47	8,57,426	10	477	6	37	6,59,019	157	2,884	11	37	8,75,779	0	0	0	0	0	0	0	0	0	0
Rychvald	3	45	3	14	1,88,561	6	63	3	23	2,43,949	4	148	4	15	2,15,828	10	184	6	24	1,89,929	3	20	3	13	1,65,309	13	54	9	33	2,62,372	10	56	10	27	3,22,985	12	31	5	18	3,05,424	3	58	3	11	2,30,734	6	167	6	27	3,23,616	0	0	0	0	0	0	0	0	0	0
Romania	0	0	1	1	2,72,355	0	10	0	2	3,19,040	0	2	0	1	2,61,607	0	1	0	1	3,18,170	0	0	0	0	1,15,039	714	902	3	4	3,19,730	2	2	2	2	2,16,981	0	3	0	2	2,72,213	0	0	0	0	1,08,604	0	0	0	0	2,73,642	0	0	0	0	0	0	0	0	0	0
Poland	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	129	2	29	3,248	0	182	0	26	14,923	0	0	0	0	0	0	0	0	0	0
Turkey	6	6	4	4	21,49,175	362	387	1	2	23,23,812	6	6	4	4	17,69,565	319	319	4	6	19,77,009	0	178	1	1	17,91,943	18	300	2	8	26,33,696	8	132	4	6	21,84,676	28	443	6	17	26,43,949	16	27	4	6	22,88,836	6	17	3	4	23,99,265	0	0	0	0	0	0	0	0	0	0
Vietnam	1	1	1	1	78,699	107	209	7	7	72,513	30	30	2	2	86,870	2	2	2	2	79,711	4	4	3	3	78,405	1	1	1	1	84,290	1	1	1	1	70,895	195	195	1	1	87,071	7	7	2	3	87,395	1	1	1	1	1,14,358	0	0	0	0	0	0	0	0	0	0
VTYC CQ	3	8	3	3	1,50,985	0	0	0	0	86,839	7	174	4	7	1,51,333	4	9	2	4	1,60,170	6	114	3	9	1,03,708	0	0	0	0	1,88,943	2	31	2	31	2,23,373	8	8	4	4	2,61,951	2	2	2	2	2,28,203	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
VTYC CZ	5	5	2	2	1,02,486	0	4	0	0	1,09,470	1	3	1	3	84,792	3	9	4	9	97,609	2	4	2	2	1,00,146	0	2	0	2	1,17,626	0	1	0	1	1,05,194	1	1	1	1	1,47,849	1	17	1	6	94,689	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
India Chennai	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Europe (NJ,RY,PL, Mor.)	30	621	18	48	11,47,585	27	1,119	24	76	12,93,819	19	817	14	54	0	23	1,247	14	84	8,89,617	16	485	9	30	8,21,498	21	1,034	17	63	12,59,948	22	803	21	72	13,48,355	19	1,334	12	65	12,16,193	23	758	13	79	9,49,075	163	3,273	17	90	12,95,801	0	0	0	0	0	0	0	0	0	0
US (Brazil+ Mexico)	63	2,025	3	12	4,08,145	6	1,216	5	19	5,22,229	6	956	2	12	0	2	876	2	10	4,13,099	361	758	2	20	3,99,975	2	217	0	16	4,22,860	26	355	6	18	4,40,148	1	255	1	9	4,20,019	2	151	2	8	3,19,273	12	152	2	6	3,68,233	0	0	0	0	0	0	0	0	0	0
2WSL	29	35	30	33	26,57,256	735	872	16	19	29,42,066	135	137	15	16	0	417	418	11	14	25,29,005	4	194	4	9	20,76,824	742	1,268	9	23	32,51,324	25	189	12	23	26,34,683	224	701	8	25	31,61,706	24	38	7	11	25,84,162	99	289	8	12	30,98,520	0	0	0	0	0	0	0	0	0	0
China	8	13	5	5	2,70,858	0	4	0	0	1,96,309	8	177	5	10	0	7	18	6	13	2,57,779	8	118	5	11	2,03,854	0	2	0	2	3,06,569	2	32	2	32	3,28,567	9	9	5	5	4,09,800	3	19	3	8	3,22,892	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
India (Pune+ chennai)	4	482	3	3	78,220	2	477	2	2	81,296	6	291	4	4	0	4	230	2	2	76,701	4	188	2	2	64,348	5	155	3	4	66,408	2	304	1	1	66,055	2	594	1	1	67,963	6	553	2	2	79,107	12	1,149	3	3	1,29,007	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
TOTAL ACTUAL	134	3,173	59	101	45,44,677	770	3,688	47	116	50,35,719	174	2,378	40	96	41,88,737	453	2,789	35	123	41,66,201	393	1,743	22	72	35,66,499	770	2,676	29	108	53,07,109	77	1,683	42	146	48,17,808	255	2,893	27	105	52,75,681	58	1,519	27	108	42,54,509	286	4,863	30	111	48,91,561	0	0	0	0	0	0	0	0	0	0

I wish to get the below output:-

	NOK parts in customer database - total	Real NOK parts manufactured - total	Number of official Written concern	Total number Alert + Unofficial Written concern
Apr-19	29	698	12982	22224
May-19	153	732	9333	23035
Jun-19	42	568	9549	22919
Jul-19	109	669	8401	29523
Aug-19	110	489	6169	20188
Sep-19	145	504	5464	20350
Oct-19	16	349	8718	30304
Nov-19	48	548	5118	19903
Dec-19	14	357	6346	25385
Jan-20	58	994	6133	22692
Feb-20	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
Mar-20	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!

Can anyone please help ?

Thanks in advance

Show Less

0 Replies 0 Likes

New to Qlik Sense

To show negative Value

how nagative values In qlik sens epie chart but it is showing same number for all in pie chart.

By Abhi999 2020-02-21 / 09:59 AM

2 Replies 0 Likes
New to QlikView

Help me on my issue

Hi All,i have four Date columns like Offer_StartDate Offer_EndDate ... Show More

Hi All,
i have four Date columns like Offer_StartDate
Offer_EndDate
Calendar_StartDate
Calendar_EndDate.

Offer_StartDate & offer_EndDate are in T1 table
Calendar_Startdate & Calendare_EndDate are in T2 table
i have created one Calendar_StartDate calendar object And one Calendar_EndDate calendar object
As per my requirement, i want show the Offer_StartDate and Offrer_EndDate with in the date rang which i select in Calendar_StartDate and Calendar_EndDate, but issue is "Calendar_Startdate & Calendar_EndDate" column table is independent table(isolated table). can u help me how the apply the triggers to make it work this.
Thanks in Advance.
Show Less

By devaraj28 2020-02-20 / 08:32 AM

3 Replies 0 Likes
New to Qlik Sense

Restrict one of the filters on multi KPI

Hi,I have 2 identical sheets that display several KPIs and a multi KPI. There are also 3 filters on each sheet: district, year and area.I want to use ... Show More

Hi,
I have 2 identical sheets that display several KPIs and a multi KPI. There are also 3 filters on each sheet: district, year and area.
I want to use one sheet to display data according to all filters, that is KPIs for a chosen district,year and area.
The 2nd sheet is the main one, and it displays the data for the whole organization. That is, the same KPIs but using only 2 of the filters: year and area. In order to give the user the full picture on one page I want to add a multi-KPI or a table to show the data for all districts in the organization.
The chart should be based on the district dimension, but it should always display all the values in this dimension, without filtering.
Is there a way to disable the filter itself for the specific chart? Otherwise it shows only the selected districts and not all of them.
Show Less

By adias102 2020-02-23 / 02:58 AM

0 Replies 0 Likes
New to Qlik Sense

Create new variables from mapping existing variable names

Hello, How can i create new variables from mapping existing variable names ? i have a table in an excel sheet 'customer' containing column names. I wa... Show More

Hello,
How can i create new variables from mapping existing variable names ? i have a table in an excel sheet 'customer' containing column names. I want to use the column names to map to the excel sheet 'mapping'.
I am expecting on QlikSense to create new fields from mapping file : customer_type, loyal_yes_no, loyality_years. that must be mapped to the excel sheet customer.
Please see attached exelsheets for further clarification
Many thanks
Show Less

By hd1 2020-02-23 / 02:21 AM

0 Replies 0 Likes
Qlik Sense Integration, Extensions, & APIs

IGenericObject.GetLayoutAsync() behavior on large objects

Hello, dear Qlikers!I am experiencing a rather odd behavior of the interface's IGenericObject GetLayoutAsync() function. It hangs and freezes while tr... Show More
Hello, dear Qlikers!
I am experiencing a rather odd behavior of the interface's IGenericObject GetLayoutAsync() function. It hangs and freezes while trying to calculate some heavy-duty tables.
What I do is iterate through some list of sheets and get their children and for each, I call GetLayoutAsync() function.
Is there something that I miss? The strangest thing is if I have multiple sheets to be calculated, that specific sheet which yields a timeout when is ran alone, it works.
The server also have some other heavy-duty tasks which put some pressure on the I/O and memory. It could make this process of pre-loading objects to timeout?
```
Private Sub CalculateObjects(ByVal app As IApp, ByVal location As ILocation, ByVal id As IAppIdentifier)
For Each sheetid In sheetids
                Dim obj As GenericObject = app.GetObject(Of GenericObject)(sheetid)
                Dim copii = FindAll(app, obj)                
                Dim tasks = children.[Select](Function(o) o.GetLayoutAsync()).ToArray()
                Task.WaitAll(tasks)               
Next
End Sub

Private Function FindAll(ByVal app As IApp, ByVal obj As IGenericObject) As IEnumerable(Of IGenericObject)
            Dim copii As IEnumerable(Of IGenericObject) = obj.GetChildInfos().[Select](Function(o) app.GetObject(Of GenericObject)(o.Id)).ToArray()
            Return copii.Concat(copii.SelectMany(Function(copil) FindAll(app, copil)))
End Function
```
Show Less
By catalin 2020-02-19 / 03:17 PM

3 Replies 0 Likes
Qlik Sense Integration, Extensions, & APIs

Make selection / set filter in Qlik Sense App via .NET SDK

Hello,I'm currently developing an .NET App which should control a QS App (making selections/setting filters etc.).I'm can read the current made select... Show More
Hello,
I'm currently developing an .NET App which should control a QS App (making selections/setting filters etc.).
I'm can read the current made selection in the tool live, which is great but I have troubles making selections via my app.
So my question is: How can I make a selection / set a filter on my app?
Like setting a Datefilter, a customer filter to a certain customer etc.?
```
Dim currentSelection As ICurrentSelection = myApp.GetCurrentSelection
For Each selectedField In currentSelection.Selections
MsgBox("Field: " & selectedField.Field & vbNewLine & "Selected Values: " & selectedField.Selected)
Next
```
Thank you and best regards
Show Less
By chrislemm 2016-09-23 / 06:15 AM

8 Replies 0 Likes
QlikView Scripting

How to create additional field name PNL+TYPE = Revenue IF GL_CODE=80020 ?

Hi AllMy Table after load raw data to Qlik is look like below :-SOURCEGL_CODE_GL_DESC_AmountTDS80020LOCAL SALES205297.31PMC5000200LOCAL SALES-590387.6... Show More

Hi All
My Table after load raw data to Qlik is look like below :-
SOURCE GL_CODE_ GL_DESC_ Amount
TDS 80020 LOCAL SALES 205297.31
PMC 5000200 LOCAL SALES
-590387.65

I Wish to make the table as below :-
SOURCE GL_CODE_ GL_DESC_ Amount PNL_TYPE
TDS 80020 LOCAL SALES 205297.31 REVENUE
PMC 5000200 LOCAL SALES -590387.65 REVENUE

Base on condition :-
SOURCE = TDS , GL_CODE=80020 , PNL_TYPE = Revenue
SOURCE = PMC, GL_CODE=5000200 , PNL_TYPE = Revenue
Can some one advise me how to do it ?
PAul Yeo
SOURCE = TDS GL_CODE=80020 , PNL_TYPE = Revenue

Show Less

By paulyeo11 2020-02-23 / 01:32 AM

0 Replies 0 Likes

SOURCE	GL_CODE_	GL_DESC_	Amount
TDS	80020	LOCAL SALES	205297.31
PMC	5000200	LOCAL SALES	-590387.65

customer	order id	flag order
A	145	1
A	267	2
B	211	2
B	214	3
B	189	1

Welcome to Qlik Community

Recent Discussions

Top Resources

Top Participants

Blogs

Blogs

Blogs

Groups

Groups

Groups

Events

Events

Events