Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I currently have a Pivot Table that is displaying the total number of records in different work queues, broken down by their current SLA status (Green, Yellow & Red). Sample screenshot shown below:
What I'm trying to accomplish, if possible, would be to have a couple of Qlik buttons that could perform filtering of what is being displayed on the Pivot Table. For example, Button 1 could filter out any Queues with zero records. Button 2 would filter the pivot table to only display queues that have records in a Red SLA status. Is this possible? I've tried numerous things that I've found online but haven't found the right answer or example yet.
Thanks for any assistance that can be given!
Hi experts
I have designed a master item (dimension) with three dimensions:
=pick(match($(vDimension), '[Konto.IdDesc]', '[Ansv.DivisionIdName]', '[Kontogrupp]'), 'Konto', 'Cost Center', 'Kontogrupp')
Definition of a Variable vDimension defined with this dimension, as "start" value: [Konto.IdDesc]
Furthermore a listbox with the master item "cyclic dimension" as dimension has been defined. Currently I only see the listbox with one value, the "start" value, check the attachment please.
I need the same as shown in this video: https://www.youtube.com/watch?v=mb4cr8UD7Is
How do I fix the listbox to see all three dimensions defined in the master item for cyclic dimension?
Thanks for your help, Tom
I have a variable set as vCurrentMonth showing 19 which is the Date.Chron.Month value.
I would like a textbox to display the value for Date.Month.Year (May-2024) through using the vCurrentMonth variable.
Does anyone have any suggestions on how this may be done?
Thanks in advance!
Date.Chron.Month | Date.Period | Date.Month.Long | Date.Month.Short | Date.Year | Date.Month.Year |
19 | 7 | May | May | 2024 | May-2024 |
Its showing
AuthenticationException: The remote certificate is invalid according to the validation procedure: RemoteCertificateNameMismatch, RemoteCertificateChainErrors
I tried multiple approaches but it's not working.
i have tkt_code, amount, cm2, cost of extras like so many columns are there. recently for new developemnt we have ew materail and materail desc, because of each tktcode have have different materail description., suppose one tkt code has 6 materaildesc, i have 6 rows of data for each tktcode, amount, cm2 is also same value repeat 6 time beacuse of 6 rows of tkt code lines.
previously directly sum(amount) , it will give vlaue, now i will take same formula if will high value, with same values repeted so many times, so that i need to take sum( distinct amount) for each tkt code. iam using below it is working fine.
Sum(Aggr(Only(amount), tkt_code))
i have created mastercalender in data load editor and have period in that have ytd , mtd, qtd,month year. for my ytd is default state always.
iam using below formula. to ytd data
Previously formula before adding materail description using below formula to get cytd and pytd data- both are working fine
sum({1<CYTD ={1}>}amount), sum({1<PYTD ={1}>}amount),
now iam using below below formula
Sum(Aggr(Only({1<CYTD ={1}>} amount), tkt_code)) - working fine
sum({1<PYTD ={1}>}amount)- this formula still works fine, but i should n't use this it will giveworng results, i need distinct amount of data for each code ticket code.
Sum(Aggr(Only({1<PYTD ={1}>} amount), tkt_code)) - not getting data,
Kindly help me to sort above formula, do i need to do any thing in the backend(dstatload editior) or in front end. i need to distinct sum of amount for each tkt code for previous YTD. iam attaching sample file. Please help me to resolve the issue
Hi,
I have some data exported from Shopify which is effect is a whole bunch of comma delimited tag words of a particular item but stored in a single field. In practice its something like a Tshirt in size Medium where a customer has picked multiple single items of the various colors on sale and has purchased a multi color pack of goods. I want to split up this field (which can be any length) into separate columns in a Qlik table, similar to what would happen if you imported the field as if it were a CSV without the " " around the string when it gets split into separate columns. I'm using Qlikview here.
Some example data below:
[Table1]:
LOAD * INLINE [
Order, ColorList
#43308, "White,White,White,White,White,White"
#43327, "Powder Beige,Powder Beige,Powder Beige,Powder Beige,White,White,White"
#43329, "Black,Black,Black,Black,Powder Beige"
#43335, "Powder Beige,Powder Beige,Powder Beige,Powder Beige,Powder Beige"
#43342, "Black,Black,Black,Midnight Navy,Midnight Navy,Midnight Navy"
#43346, "Black,Black"
#43347, "Black,Black,Black,Black,Black,Black,Black"
#43349, "Black,Black,Black,Black,Black,Black,Black"
#43354, "Powder Beige,Powder Beige,Powder Beige,Black,Black"
#43354, "Black,Cherry,Black"
#43361, "Blood Stone,Blood Stone,Midnight Navy,Midnight Navy,Black,Black,Black"
];
Ideally I want to display the above data as:
Order White PowderBeige Black ... etc.
#43308 6
#43308 3 4
#43329 1 4
... etc.
If the formatting above doesnt get mangled when I post this I hope you'll get the idea. I simply want to create additional columns using the unique names of the colors as the title of the additional columns and then put the count of the number of times that color name is repeated per order line in the ColorList string(field).
With help from other posts in this forum
https://community.qlik.com/t5/QlikView-App-Dev/Split-String-Function-In-QlikView/td-p/221912
https://community.qlik.com/t5/QlikView-App-Dev/How-to-get-Subfield-value-count/td-p/488174
https://community.qlik.com/t5/New-to-Qlik-Analytics/SUBFIELD-and-CountIF/td-p/1786994
and https://www.bitmetric.nl/blog/qlik-sense-subfield/
its fairly straightforward to determine the unique items in the ColorList strings and also to count them, and then using set expressions and manually creating a Table report column per unique color name achieve a result.
For example by doing this:
LOAD Order, SubField(ColorList, ',') AS UniqueColor RESIDENT [Table1];
LOAD Order, SubStringCount(ColorList,',')+1 AS ColorCount RESIDENT [Table1];
However, the caveat is this isnt easily scalable. Doing it with 10 items is easy, but when I have a list of 500+ colors and 50000 records I need to find a way to do this for much longer comma delimited strings and have a way of in script splitting up this string into separate fields or a subtable of the color list items which I can then further manipulate as desired.
This expression works (obviously I change the color name in the {' '} section for other colors in additional expressions per color but this doesnt scale well so its a lot of manual model front end maintenance to keep this updated.
=Count({<UniqueColor={'Black'}>}SubField(ColorList,','))
Can anyone suggest a way I can do this in Qlik code (or some other method that's generic and automated) for different delimited color names (or any other tags) in the loaded string automatically in Qlik.
Thanks
Buenos dias,
necesito armar un Grafico por mes y por Lugar pero que la ultima columna sea un Total de los otros meses
LUGAR | Mes | Target | Valor Actual | B / (W) |
XXXX | 1 | 52.91416497 | 90 | -61 |
XXXX | 2 | 192.4980829 | 109 | -4 |
XXXX | 3 | 213.8462115 | 210 | -94 |
YYYY | 1 | 57.16937735 | 137 | -105 |
YYYY | 2 | 207.9782521 | 151 | -39 |
YYYY | 3 | 231.0431388 | 122 | 4 |
ZZZZ | 1 | 179.1306451 | 539 | -441 |
ZZZZ | 2 | 651.6649331 | 625 | -273 |
ZZZZ | 3 | 723.934883 | 577 | -185 |
HHHH | 1 | 76.34358409 | 26 | 15 |
HHHH | 2 | 123.3615513 | 24 | 42 |
HHHH | 3 | 307.3236405 | 28 | 138 |
RRRR | 1 | 5.15686373 | 7 | -4 |
RRRR | 2 | 18.76031461 | 7 | 4 |
RRRR | 3 | 20.84084239 | 4 | 7 |
TTTT | 1 | 85.96053278 | 107 | -61 |
TTTT | 2 | 312.71849 | 135 | 35 |
TTTT | 3 | 347.3991187 | 232 | -44 |
YTD | YTD | 3808.044627 | 3131 | -1065 |
El YTD que tengo hoy es el total de los lugares y solo necesito de XXXX
Me podrian ayudar, Muchas gracias!
Hello Qlik Community,
We have migrated the server application data which is D(net app) drive to some F(pure) drive for the storage migration activity from net app to pure.post that we have renamed that F drive to D drive by stopping the services for both Qlikview and nprinting with the help of only Qlikview admin credentials.
Then we restated the server and started checking the qlikview and nprinting applications.
I'm able to open qlikview QMC and access point but somehow Nprinting credentials are not working for me to login ,even the admin credentials are also not working.
I'm not sure ,if this is because of the storage migration or due to the drive letter change and there is nothing changed in C drive where the application is installed.
Please let me know is there anything I need to check on this immediately.
Thanks in advance.
Hi, what is the status of a request to add a MinIO connector please? This closed thread has a link to an idea on the ideation site, but I do not have permissions to view it. (I assume that is the case for others as well.)
Thanks
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!