Hello,
I have a QlikView report containing differents Qlikview objects: color graphics, a basemap image ...
With QlikView the restitution is ok,
With accesspoint colors are ok for bar graphs, curve, sector ... but KO for the basemap and the bar graphs placed on it.
See Attachment

QlikView 12.10

User parameters / print : Color forced

Any idea about that ?

Cordially - Jacques

Hi, 

I am looking to use one qvd file to store 12 hours of data. Then at the end of 12 hours, I want to concatenate that data with another qvd file that serves as a historical data file. I'm hoping this will speed up my load time.  Can someone help me get started with this process?  How do I specify when the 12 hour data should be moved to the historical data? What are some key commands/functions others have used when doing this?

Thank you! 

Hi Everyone,

I am able to load data from excel files available at SharePoint location however as a next part of automating end to end process I also need to upload data back to SharePoint using the same Qlikview application.

Can you please extend your help & support here to achieve this.

Many Thanks in advance !!!.

Hi All, Previously I had 6 years of data but now I have reduced it to 3 years.

I used below reduction formula for this.

Let vStartYear = year(today())-3;

LOAD
Year,
Data,
...
FROM ... where Year >= $(vStartYear);

But in some of my KPIs developers kept Year= blank to avoid any selection on Year column but it sems that because of the same filter my data is not matching.

My expressions are as per below,

OrderBookValueLC= Num (Sum ({$<[%Date Selection] = {'Sales Document Creation Date'}, Year =, Quarter =, Month =, [Year Month] =, [Year Week] =, Date =>} [Orderbook Value LC]), '# ##0')

OrderBook Documents = Num (Count ({$<[%Date Selection] = {'Sales Document Creation Date'}, Year =, Quarter =, Month =, [Year Month] =, [Year Week] =, Date =>} DISTINCT If ([Orderbook Value LC] > 0 OR [Orderbook Value LC] < 0 OR [Orderbook Quantity] > 0 OR [Orderbook Quantity] < 0, [Orderbook Document Number Count])), '# ##0')

OrderBookLines = Num (Count ({$<[%Date Selection] = {'Sales Document Creation Date'}, Year =, Quarter =, Month =, [Year Month] =, [Year Week] =, Date =>} DISTINCT If ([Orderbook Value LC] > 0 OR [Orderbook Value LC] < 0 OR [Orderbook Quantity] > 0 OR [Orderbook Quantity] < 0, [Orderbook Document Item Count])), '# ##0')

Could you please suggest on this.

I have a Extraction Date field but it has no sequence to it. For example I have dates like

05/1/2019

03/1/2019

2/1/2019.

I always want the Max Date and the  Previous from Max Date. In this case I need 5/1/2019 and 3/1/2019. I know how to get 5/1/2019 but how will get  3/1/2019. 

Hi, can anyone assist me with this error?

Every time I try to export a PDF or Image file it goes perfectly but when I close and open another application I keep getting this error.

I've checked and the application is really changing from one to another. If I switch it back, it exports ok again.

The error is pretty concise and not much informative: error: {code: 2}

...

Hi All qlik Experts,

Have a nice day.

I have requirement like , i want to display  trends data month over month for last 12 months here , if i am in 2020 Jan right

so, in my line chart i need to display for second  dimension 2020 for Jan 2020 and rest all are 2019 year should be display as a second dimension for all one value i.e 2019. 

Please suggest me here how to do ...

Thanks in advance....