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 

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! 

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

@BrunPierre