Hi, 

I have the logic below to look at values as at today's date but I also need to show the same calculation for 'Current Month' and another for 'Current Year', any idea how I change below to for the two additional calculations needed please?

=Sum({<[AU_Date]={'$(Today())'}>} [Total_Sold] )

Hello everyone,

What we are trying to accomplish -

Allow end users to create bookmarks on sheets ,  but this would not allow users to create other objects such as stories, other sheets, or duplicate the sheets etc. ONLY Bookmarks

and in our stream, we have multiple applications, but this rule should be applicable on only one application that is specific to be used by ipad users, and for rest of the other application user can create duplicate sheets.

Please suggest how to acheive this, I tried to modify the security rule but it's not working.

Thanks in advance

Hi All,

I have an application with PostgreSQL data connection type.

Once I imported it to a client which works in offline environment, the application is not running.

I accessed the  Data Load Editor of the application and found out that the Data Connection on the right side does not load.

I found this article:

https://support.qlik.com/articles/Basic/Data-Connections-not-visible-in-the-Data-Load-Editor-in-Qlik-Sense-3-2-or-Error-11041-11043?articleId=Data-Connections-not-visible-in-the-Data-Load-Editor-in-Qlik-Sense-3-2-or-Error-11041-11043

From what I understand, the connectors package is having an online authentication which caused failure when working offline.

My question - is there a way to use PostgreSQL connector in offline mode as I don't want to use an ODBC data connection solution?

Thanks.

Hello

which shared storage solution is supported by Qlikview server .

i'v found here that the only one is windows shared files and nas in only few cases .

https://qliksupport.force.com/articles/Basic/Does-QlikView-Support-NAS-Storage?articleId=Does-QlikView-Support-NAS-Storage

Can you give more details about that ? in which case is supported on nas storage ?

Thank you

Dear Friends,

I have created following  variable  in Qv document

let  vTdate=num(Date(MakeDate(2019,10,31),'YYYY/MM/DD'));

and I have written following expression in my pivot table and it works perfectly

SUM({<FYYYYMM={$(=vTmonth)},POL_TYPE={'R','A'},HISTORY={'Y'}>}PREMIUM)

but when I try   to change the expression as shown below it does not work

SUM({<FYYYYMM={"<=$(vTmonth)"},POL_TYPE={'R','A'},HISTORY={'Y'}>}PREMIUM)

I want to change the equal to less than or equal. Pls help me to correct the expression

I've got a Currency field that has values like, USD, EURO and UK.

I want to translate UK and EURO to GBP and EUR respectively.

I can do this quite easily in an If formula because there are just two values that need translating, the rest should stay the same. i.e.

If([Currency]='EURO','EUR',If([Currency]='UK','GBP',[Currency])

However in the future there may be currencies that need translating and the nested If statement could get quite large. I'm wondering if it's easy to set a default value using Pick and WildMatch (or Match). The following would translate UK and EURO for me but I would lose USD etc. 

Pick(WildMatch([Currency],'UK','EURO'),'GBP','EURO')

I have a simple table with four products:

Products A and B are very important to my users, so they should be shown in a table on their own.  There is also a filter allowing a user to select a product:

The measure in the table is calculated as: Sum({<Name*={'A', 'B'}>} Value)

This is so that the table shows records for A and B when they are selected or possible.  But if a user selects a Product that is not A or B, then nothing should be shown.

This works ok when A and B are selected or possible e.g.:

But it show this when I select Product C:

In this case I want to see no rows in the table - A and B are not selected so my users don't want to see any data.

I know I could turn off 'Include zero values' in Data Handling but this is a problem if the value for A or B is 0.  E.g. if the value for A is 0, it's important for my users to see this - they need to know that A has 0 value.

I feel like there is an obvious solution to this problem but I can't think what it is.  Any ideas?