topic Re: How to label X axis at 2 min interval in QlikView

How to label X axis at 2 min interval

Anonymous — Thu, 30 Nov 2017 07:37:46 GMT

I have a bar chart where my min and max x axis values are 7 am to 7 pm. the data behind is at seconds granular level. there is a transaction happening at each second. I dont want to show each second timestamp for my dimension label. instead, I want the dim label to appear as shown below>>>>>>>>> at 2 min intervals; the transaction date field (which is the dim in below chart) is in a format- '6/20/2017 7:01:35 AM' format. how do i achieve the result so my boss will be happy

Re: How to label X axis at 2 min interval

kaushiknsolanki — Thu, 30 Nov 2017 07:58:21 GMT

Hi,

Check this post and take some idea.

Radar chart - 360 degrees

Regards,

Kaushik Solanki

Re: How to label X axis at 2 min interval

sergio0592 — Thu, 30 Nov 2017 08:44:33 GMT

Hi, I think you can manage it with as text color :

=if(match(mid(Timestamp,13,2),'00','02','04','06','08','10','12','14','16','18','20','22','24','26','28','30', '32','34', '36','38', '40','42', '44','46', '48','50', '52','54',

'56','58')>0,Black(),White())

I have tried and it works for dimension in straight chart but don't works in a bar chart. I don't understand why.

Re: How to label X axis at 2 min interval

Anonymous — Fri, 01 Dec 2017 03:21:25 GMT

hi Jean-Baptiste Thanks for your help but that did not work for me.