Hi Team,

How to generate a report based on dimension values in Qlik Sense SAAS version.

for example we have region with east & west values. The report should be generated for both east and west separately and dynamically. Can you please suggest a solution ?

Thanks

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,

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

hi,

ive used ODAG to get the list of values filtered for a field.  now im exposing my fieldnames as business filed names and my field names have spaces embedded in the name.

how do you use field names in ODAG if there are spaces in them?

for example in the binding section 

SET <FIELDNAME HERE> ='';
OdagBinding:
LOAD * INLINE [
VAL
$(ods_<FIELDNAME HERE>){"quote": "", "delimiter": ""}
];

what if your field name hsa spaces?  what is the convention to use in place of spaces?

thanks,

edwin

I am connecting to a list on Sharepoint 365 to bring it into Qliksense. 

The "Person or Group" column type from Sharepoint is coming into Qliksense as numbers. Not sure what the numbers mean -  Is there any way to pull the column as a string?

Any help is appreciated. Thank you!  

Hi Team,

I am getting below error when loading data in Qlik SAAS environment.

Your quota limit of 5120.0MB was exceeded. you loaded 10098.1 MB.  Reduce your data within this application or buy additional capacity.

Please suggest a solution on this. Can you tell me some ways to reduce the data.

Thanks

Vishnu

hi 

In my table i am having two date 

1.order date

2.Delivery date 

but when i am using Canonical Date the count of delivery not coming correct as per my source 

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