Qlik Sense

Is there any way to replace '-' by 0 in QS pivot table?

I have a measure to count the number of record by using count(1). But the zero count will be shown as '-' instead of 0 .

How to display 0 for these case?

Hello, 

I am trying to replace the '-' with Zeros. I have looked around and tried alot of surgestions but nothing has worked yet. 

Does anyone know how to do this? 

I've very new to Qlik so the more you could spell it out the better... 

Thanks!! 

Hi All, need your help in calculating accumulated month wise sum in Balance Sheet pivot.

Attached is the current table which is having correct data with below formula:

RangeSum(before(Total SUM(FCBAL), 0, ColumnNo(TOTAL)))

Now my requirement is user just want to see last 3 years figures, which is 2017,2018,2019.

If I filter Year field, accumulation for 2017 is not happening. So for 2017 column, data should be accumulated from 2011-2017 and so on. I need to do it in front end.

Any solution on this please?

Hello,

I have a question about dates in dimension.  What i want to do is to show last 5 months as dimension in a bar chart, as my file is growing i don't want to show all the available dates, but only the last 5 month.  

What i have for now (not working) is below code:

=If(([Cycle Date] > {$<[Cycle Date] = {$(=date(AddMonths(max([Cycle Date]),'-5',0),'MM.YYYY'))}>}),date([Cycle Date],'MM.YYYY'),Null())

This should only show the dates that are from max month to -5 months, but i get invalid dimension in bar chart and i get all the dates in a table when the formula is shown as a measure. 

Can someone please help me with this?

Thank you in advance.

I am pretty much comfortable with Power Bi where I can use Parameters to pass the user input in pop up box and filter records based on it. But not sure how i can do it in Qlik Sense. Please help..

For example, Suppose my datawarehouse has Date field and updated counts of some dimension(Software updates), i can put filter to select existing counts of particular date, but user want to in what dates 10000 updates had happened then?

Here user has authority to give user input in run time, he can give 30000, 400000, 3001 , anything.

For similar scenarios, i would use parameter in Power BI and dynamic variable will link to updated count field, Parameter will allow user to enter numbers what he want, and same will go dynamic variable for filtering / calculating / finding out the dates ...

I am not sure how to do it in Qlik Sense, Please help.

Hi Everyone,

I am using Rank function in my expression. Below is the table, where I am ranking Count(Accounts) for each person and showing the table. However, I need to consider Date while calculating the Rank function. For the same #Accounts, I need to consider the Min Date having lowest Rank. For Ex: BBB, CCC and DDD is having same #Accounts of 6 but the rank should consider the Date order while calculating. So BBB should be 2, CCC should be 3 and DDD should be 4. How to achieve that?

Current Rank Expression: Rank(Count(Distinct Accounts),4,0) and I kept number format.

Criei um marcador e defini como padrão.
Antes da atualização para versão April 2020 estava funcionando perfeitamente e ao abrir a app o filtro era realizado, mas após a atualização para a versão Abril de 2020 não executa o filtro vinculado ao marcador
Alguem já se deparou com este erro ?

Hi ,

We are currently in Qlik Sense Enterprise Sept 2018 version and planning for an upgrade (to have visualisation bundle) Can some body let me know

1)if there is any cost involved in upgrading 

2) what is the process to upgrade

3) which version would you recommend to upgrade to considering stability and the current version.

Thank you 

Hi All,

I have a requirement wherein I need to automate the process of exporting QlikSense reports to PowerPoint(without using Nprinting)

It is like, just on a click of a button I should be able to generate a Power Point with all the Sheets in my QlikSense Dashboard.And the power Point (PPT) should be in editable format.

Have someone come across such scenario ever ?

Please suggest.

Thanks,

Rathish.

Hello there,

After trying multiple combinations of these if statements, I can't wrap my head around it to get it working properly. I'll try to lay out the problem as best as I can so that you guys can help me out - hopefully:

Data Table:

I have this layed out on a pivot table and the need is to handle the dimension so that the table shows:

01 - N/A, because these 'lines' are to be there independent upon the type of discount chosen;

02 - The lines that relate to the SelectionType.

I have been trying the following, but without success as it doesn't hide the rows not related to the SelectionType. It keeps showing everything:

=if(Description = 'Expenses',
	if( not '$(vExpandDesp)' = 'Expenses', null(), Description),//This is for a couple of lines that expand or collapse depending on another variable
    	if(SelectionType = 'N/A', Description,//This is to keep 'N/A' unhidden
        	if(SelectionType = vSelectionVar, Description, null())))//This is to show only rows that meet the variable criteria

 Appreciate your time.

Hi All,

In NPrinting, the reports are not replaced or published as a separate file when we run the task more than once in the hub destination on the same day. Can anyone tell me how to replace the report in the hub by the task?

Thanks

I have a default bookmark which filters dynamicly all hours up to the hour when the app was loaded at last: myHour <= eReloadTime where myHour is the time-field in the data and eReloadTime is the variable that contains the hour when the app was loaded at last.
Now I want to provide a button which resets that filter setting like applying the default bookmark without changing the sheet but just set the filters to default.
Can anybody help me?
Thanks in advance.

Hi, 

I have two standalone Qlik Sense servers hosting apps. I now want to change the architecture by turning one server to Central node/ scheduler and the other as RIM/ Consumer node. Is there a way to achieve this without uninstalling and reinstalling the servers?

Thank you

Monjay

Hi All.

I have received a task which is to basically create a report based off a number of fields of a excel file. The output the user wants also includes a field which is basically a record ID, which is a number which increases for each record.

They would like the letter P with a number of 0's until the number, and the end of each number to include 0032. For example;

P0000000010032

Record 1 will be P0000000010032, record 10 will be P0000000100032, record 18 will be P0000000180032 etc. 

I have used  AutoNumber(RowNo(),"Master Policy Number")  but this just gives me 1 accross each record, I have tried including -1 and this just makes the number not what we want. Any suggestions would be appreciated, thanks in advance.