Welcome to Qlik Community

Hi all

Can you please please let me know if I can set the NPrinting Excel Chart Y axis to show as 0% for minimum and 100% as maximum values. It keeps on showing up as 120% max or 80% minimum.

Also can the values be sorted as max to min and not by alphabetical order.

Many thanks 

D

Hi Gurus,

I am trying to transform an xls into a more reportable format in Qlikview, xls format is unfortunately is as below

I want to transform this data into below format , I tried cross table but was not able to work out how to do it easily. Please help !

Hi All,

I have developed a bar chart, i have 2 dimensions on y axis (AdmissionType, AdmissionMonth). When i select sheet for two months it shows grouped chart. See scenario1.png in attachment.

Now i want to select only May Month of ABC AdmissionType. But when i am clicking on May it is selecting both May and June months. Basically it is selecting AdmissionType='ABC'. See scenario2.png in attachment.

But i want to select only May month and get only 11 records of May month. It this possible?

Hi All,

Below Script work fine , it will generate 2 Table name depend on the file name i load  :-

For Each i in '$(vFile2010)','$(vFile2011)','$(vFile2012)','$(vFile2013)','$(vFile2014)'
LOAD
'$(i)' as SOURCE_,
Date( Date#([Posting Date], 'MM/DD/YYYY'), 'DD/MM/YYYY') as [date],
ApplyMap('MAP_ISDN_REV',[GL Code],'REVENUE') as [rEVENUE],
[Transaction Type]
FROM
$(vRAWPath)$(i)
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
NEXT i;

For Each i in '$(vFile2015)','$(vFile2016)'
LOAD
'$(i)' as SOURCE_,
date#(@58:77T,'DD/MM/YYYY') as date,
FROM
$(vRAWPath)$(i)
(ansi, fix, no labels, header is 0, record is line);
NEXT i;

May i know how can i assign the table name to be alway equal to TABLE 1 and TABLE 2 not depend the file name i load ?

Paul

Below is my Data model :-

Hi,

I am working on maps in Qlik.  My dimension Is name of the areas and measure is resident/population *100000.

Now the issue is when the measure is zero I could still see the polygon for that region and I don't want to.

I want to only see the regions which have the number in it and want to filter out the polygon of the regions with result zero.

Can anyone advise.

Thanks

Hi there,

I am trying to create a Map Visualization also containing a layer for continents.

In Qlik Help contoninent is listed as one supported type of data, but unfortunately only 'Australia' is detected.

Entries like 'Africa', 'Europe', 'Asia', 'South America', 'North America' are not shown. Is there a list of valid entries that Qlik can interpretate?

Hello guys, 
I'm trying to create a chart with Date as Dimension and the following expression:

=avg({1 <STCK={'CVCB3'}, DVPG={'> 03/01/2020'}>} VDAF)

I don't know why but it's not working, it shows NO DATA TO DISPLAY,  but I'm sure there are available data to display. 

My intention is to create a chart where Date (DVPG) is a dimension, and the expression is the average of VDAF values, from 03/01/2020 up to today!

How can I do it?

Thanks

Hello,

I have a tough question here and since I'm new I don't know how to solve it best. I have two tables.  These tables have the (Shelf.No or others) and Coordinate as the connected Key.  

Table1

Table2

Table1 consist error reports from logistic workers who realizes in the shelves of their corresponding Sectors, errors like  "empty shelves", or someone accidentally filled the "wrong material". Then the logistic workers uses the  SAP-UI to file a report. For additional information they just need to fill in the 4-digit coordinates in which shelve the error occurred. SAP interface will then automatically create an unique Error No. with a date/timestamp. Qlik gets daily updates from SAP of these reports. Note that this table also consist of reports without a shelve no., since also other departments uses this user interface to report other not shelve and logistic  related problems. 

Table2 is a self constructed Excel Database.Since the 4-digit error report doesn't tell me where the actual problem, Sector  or even Material occurred, so this Table is compulsory. For example it tells me that the shelve No. 2222 consist the Material C1111111 and the shelf is in department sector Area11:

So I also could count and  visualize which material or which sector made the most problems.

The shelve No. is unique but other shelves can of course also contain the same material. And the sector is of course also not unique, since a sector contains multiple shelves. Normally Table2 is "fixed" there is no automatic update, since coordinates won't change. 

Now its not a big problem if Table2 never changes. But since production lines and their materials will change from time to time I have a big problem to return the correct values for my bar diagram and so.  So on a monthly basis we sometimes decide to exchange Materials of a few shelves. That means for instance Shelve No.2222 might changed from C1111111to Material "C2222222" all of a sudden. 

The problem that occurs now: The old error reports  in Tabe1 that counted for the old material C1111111 will also counts for C2222222, instead of making a cut and reset the error of the new exchanged material of the shelf to zero, since I'm having a new material there now and want to start to make a new count with that material.

 But we also don't want to lose the historic data of the past when the shelf still contained the old material. Ideally the bar diagram should show both bars . Shelf No. 2222 with new AND old Material.No accumulation of both count in one bar, it has to be counted separately.

Every month or two I do  a export of the excel data from the shelf system. I can compare the data with my old excel export to check if there is any changes in materials in the shelves. I will never know exactly when the material was changed. It really depends on how often I check these, but there is NO timestamp when it got replaced with another material. I need to make a monthly update myself.  So there is always a little subset how the errors should be account for: for the new or old material. I can use end of month, respectively the day I manually update the excel sheet as the moment where I start to count for the new material. 
The only thing I can say, is that I can change the Excel sheet of the Shelf Coordinates to help me count right. But I don't know how to do it.  

That was a long one, but I hope some expert can guide me through the right direction. 

Thanks in advance and stay safe!

Dears,

I'm using a FOR EACH Loop with 2 Loads inside, something like this:

For Each Sticker in 'AZUL4', 'ITUB4', 'CVCB3'...

Each Sticker is a file, loaded online...

DemonstrativoResultados:
LOAD... From...

Join (DemonstrativoResultados)
LOAD... From...

Next Sticker

So, every time I get a new file, I'm loading everything again and it's obviously unnecessary... 

My question is: 
How can I load just the new file, and insert it in my project without losing all old data?

Check this example:
Let's suppose I have the files 'AZUL4.csv' and 'GOLL4.csv'; I'm currently doing something like this:

For Each Sticker in 'AZUL4', 'GOLL4',

DemonstrativoResultados:
LOAD... From...

Join (DemonstrativoResultados)
LOAD... From...

Next Sticker

And now, let's suppose I got a new file, called 'ITUB4.csv'

I don't want to load 'AZUL4', 'GOLL4', 'ITUB4'. Is there any way to just load the 'ITUB4' and add it to my database?

Thanks for your attention,
Best regards