Welcome to Qlik Community

hi,

i have a few action buttons on my sheets, one of the actions are not selecting the any of the field values within my field "Process", however all other actions are working fine so im not sure what im doing wrong? 

my action is set up on the sheet as follows:

Action # 1 = clear all selections = working fine

Action #2 = "Select values in a field"  = working fine

Action =3 =   "Select values in a field", Field = Process, value  ='T/A'

i dont understand why Qlik wont select "T/A" for me as there is data there for it after all actions are done (see attached image)

anyone know what im doing wrong? 

thanks 

Qlik Sense doesn't build the associations for the tables uploaded by incremental load.

There are 5 tables with 5-10 columns. I created the proper association between them. After that I added this simple script to get new set of data on regular basis:

for each file in filelist('lib://Amazon_S3_1/')
IF WildMatch('$(file)','*.csv') THEN
LOAD *
FROM [$(file)]
(txt, codepage is 28591, embedded labels, delimiter is ';', msq);
END IF
next file

and create Scheduled reload. (same 5 tables added to S3 bucket each day).

Column names are same and I can see these data into Analyze tools. But Qlik doesn't see any relations between new tables. In the Analyze tools I don't see any association between uploaded tables.

What the reason for such problem? Thanks in advance!

I have a GRID type container with 2 drop down containers (A- 5 charts and B Straight table).  Is it possible to sort different columns in a  straight table of container B depending what chart i Choose to show in Container A?

For Example, Container A shows COST CHART. I want Container B to sort the data in descending order of COST VALUE.

Example B:  Container A shows VOLUME CHART. I want Container B to sort the data in descending order of VOLUME VALUE.

I don't have qliksense. I am only using QLIKVIEW. Would like to seek help on what expression to use. I believe this will use a certain conditioning? Thanks for the help

The image consists of 3 lines in a line chart

I have 2 dimensions and only 1 measure

if I change line style to dotted it is changing for all 3 lines

The requirement is to make 2 lines solid and 1 as dotted

Please Check how can I do it.

Hello QlikGeeks,

I have a button on my QVW which has show/hide function. User can show/hide sheets as per the requirement and generate an on-demand report using NPrinting. The generated report has all the sheets even-though they were hidden on the QVW. May I know how to apply the same hide feature for NPrinting reports?

Thanks in Advance,

CVR

Qlik NPrintingQlikView @Frank_S  @Lech_Miszkiewicz  @Sonja_Bauernfeind @sunny_talwar 

Hi Guys

I want to create a formula which looks for all outstanding paperwork in %. so the formula will need to look at all oustanding paperwork(at any date range), then taking the value of the oustanding paperwork and then dividing it by current month's revenue.

Oustanding paperwork: LoadSendToInvFlag='N'

Revenue: DrValue

current month: [LoadDate.autoCalendar.Date]

Hope this makes sense.

Thanks in Advance

Hello everyone,

I need to load a table which has a time stamp that doesn't match how the it should be formatted.

Also, I want to be able to limit how many days back I load.

This is how the "date" looks like on the MongoDB:

3/1/2020, 12:00:03 AM

And this is the code:

Let vEndDate = text(date((Today()-2), 'YYYY-MM-DD hh:mm:ss'));

LOAD _id,
if([value] > 0.0,[value]) as bat%,
agv as batAGV,
[time] as batTimestamp,
loop as batLoop;

[agvBatteryLevel]:
SELECT [_id],
[value],
agv,
[time],
loop
FROM faults.agvBatteryLevel WHERE ( [time] > '$(vEndDate)' );;

Any help would be appreciated.

Thank you

Data is sacred. Data is valuable. Data is so very important…Data is also delete-able. Let’s avoid that from occurring, especially on someone else’s part. Introducing the Data Consumer Role. The Data Consumer cannot move, edit, nor delete your data. So that means, as a Data Owner, you can be confident of access authorizations, as well as increase ease of audit reviews, and enforce federated authentication on data connections. And as a Data Consumer, you can access data confidently and securely.

For more information, visit this QlikWorld 2021 On-Demand breakout session (00:02:15-00:06:44) for an overview of the various different roles and uses cases within Qlik Sense.