So  a picture is worth a thousand words  - 

I'm recording activity on our SQL server to show high resource / long running queries daily/weekly etc.

I'm trying to set-up an axis without doing any conditional stuff in the dimension column, so users can click the relevant sections and not see a long   IF(a=1 and b=1,c,d)  instead of myDimTimeOfDay.

The top  axis uses a time field imported from SQL server as 'HH:MM:ss.fff tt' format.   

The bottom axis uses "=Time(Frac(WAT_Collection_Time))"  (Time portion of a TimeStamp )

Is there a way to force Qliksense to format the SQL imported time dimension in the load script to display the same as the bottom one?  I'd rather the user didn't have to see the whole Time(Frac( stuff when selecting etc.. 

I'd like to use bookmarks in Nprinting. I already have a bookmark in Qlik sense, but I don't know how to use it in Nprinting. I'm not sure if it's because of the type of installation (Designer). 

Can anyone help please?

Hi all,

I have a selection of list boxes that are opened / closed depending on the push of a button. 

I want to be able to make it so when I click the button to open another list box, all other list boxes close.

So essentially I only ever have one list box open at a time.

Any suggestions?

Thanks

Hi team,

I need this kind of output..

However, We need to calculate the Current and New column.

Formula for Current is = Sl num*Bonus*1000000

Formula for New is = Sl num*IncrementalBonus %*1000000

Formula for New is = Sl num*IncrementalBonus %*1000000+H4

Formula for New is = Sl num*IncrementalBonus %*1000000+H5

Formula for New is = Sl num*IncrementalBonus %*1000000+H6

Formula for New is = Sl num*IncrementalBonus %*1000000+H7

Formula for New is = Sl num*IncrementalBonus %*1000000+H8

Formula for New is = Sl num*IncrementalBonus %*1000000+H9

Kindly Help me in this

hi there,

similar to this chart in the upper right at 2:30 https://youtu.be/RkVDi0b2hmk?t=150

I want to create a combo chart with a metric on the left and another target metric using lines and the right axis. as seen in the video, this doesn't make sense if those two axis don't align and share the same scaling.

so is there a smart solution to align those two ? automatic scaling works good for a single axis, but not for both

I came up with calculating the scale limits for both like

=if(
max(aggr(Sum({<Version={'$(=only(RefVersion))'}>}Value),[Date...YearMonth]))
	>max(aggr(Sum(Value),[Date...YearMonth]))
,max(aggr(Sum({<Version={'$(=only(RefVersion))'}>}Value),[Date...YearMonth]))
,max(aggr(Sum(Value),[Date...YearMonth]))
)

which translates to: if(left axis > right axis, left axis, right axis)

but this is a very fragil approach and is also doesn't react two changes of the x-axis.

any ideas ?

thanks;

alex

Hi Expert

I want to know if there is any process to Disabled TLS V1.0 and TLSV1.1 and Enable TLSV1.2 in QlikSense September 2018 version or in higher version?

Thanks a Lot

Fernando

Hi all,

I want to build a chart where the height of the columns are the COUNT OF WORKBOOK,  AVERAGE PER USER: 

The structure of the data table is the followiing: 

Table: 'Query Detail - Workbook and Worksheet'

With this table, I want to build a graph with dimension "month" and with measure "Count of workbook, average per user". In this case, the result of the measure for desember would be 2.5. 

In powe BI(DAX), the expression is the following: 

Count of Workbook average per User =

Hello, 

we are using qlikview 11 and GeoAnalytics.

we have some layers with (in/Out) Resolution Limit, in order to do drill based on level of zoom.

But sometimes( lets say most of the time) we could not see layers and it needs some action ( such as click on one button or opening the layer and ....)

In your opinion what could be a problem and does any workaround comes to your mind?

some extra information :

• we tried with variable and fixed number as  (in/Out) Resolution Limit in layers.
• We tried to use Group in order to impliment drilling ,But we should change manually dimention of the group and the layer could not undrestand just with name of Group as Dimention and Restrict Drill Down option.
• we tried with one variable which changes every 15 seconds( based on now() function) and put trigger on this variable,in order to  reset every 15 secons .But we saw 2 problems :
  • since we need auto zoom, when trigger was executed ,the map always starts from starting Point( Max zoom Out )
  • since function Now does not work from access point correctly and we could not see automatic updated value, It needs clicking on dashboard.

another question : Is there any function in order to get zoom level of the Map in geoanalytics?

Thank you in advance.

Regards,

Matsa

Hi,

My name is Victor, and I'm new on this Community.

I have a question regarding GeoQlik. I've inserted the object, but the map isn't uploaded. I don't understand why is this happening. Few months ago worked. It is possible to be a server issue ?

Image in attachment