Hi ,

I have to add expression as value in pivot table.

expression should be 1 or -1 value(like value=1,-1).I need to show in expression if value is 1 then i need show upper arrow with green colour ,if the value is -1 need to show down arrow with red colour.

please explain me how can put arrows in qlik sense?

Thanks,

Rajesh

HI,

          Every one i  have  a bar chart with a cyclic group plus a dimension and i have only one expression which is 

           count ( distinct  units) / count ( total  distinct  units )  and this expression is represented as  percentage . But  this

percentage is not summing unto 100  %. and the reason behind is   " count ( total  distinct  units )  " is not  calculating

properly. When  i  changed the bar chart to straight table to find out the issue ,  the denominator value should be a sum of

rows but its getting expression total . So  any one can tell me on how to get sum of rows value in the denominator , i tried

aggr function , total <dimension 1, dimension 2 > both of them didn't work 

Hi Masters,

If a customer belongs to a specific category, we do not want to disclose the customer name; thus I was wondering if it is possible to replace the customer name with "Customer 1", "Customer 2", "Customer 3" ...etc during the load.

Therefore, every time the category falls under "CMarket" we want to replace the customer name by "Customer" + "Autonumber" = Customer 1, Customer 2 etc

The numbering should be automatic for every new customer under CMarket category.

Currently:

Expected:

Thanks for your help

Hi Experts !

In my db month field is maintained in numeric form i.e 1,2,3,--12. and year field is also numeric like 2018,2019 and so on.

I want to display month year as a dimension in a bar chart. Any Ideas of how to achieve this field inside QV.

Thanks.

Hello, I don't know if this requires a total rewrite but having difficulty getting the count of AD_Account_Name to not include NULL's from the below. Does anyone have any tips?

Count (distinct (if([AD_LastLogonTimestamp.autoCalendar.Date] < Today()-90,AD_Account_Name)))

Thanks

Patrick

Hi Gurus,

I have a scenario where I need to display a total as the value of existing column and not the sum or average of all the columns.

The original data is like below:

And I have converted to Pivot as per requirement as below

Now as the values for AM PM an ND is being calculated as the average, so the partial sum (Total) for Census Period is also showing as average of AM,PM and ND. 

Only for Census A,I want the total to be displayed as the value of ND only i.e. 30 and not 29 in the above case.Rest all Census can show the value as usual as they are showing now.

I can achieve this using set analysis but can't find any way to write it for the total. Any pointers will be highly appreciated.

Thanks

Samir

I have a customer table with Customer and UpdateDate,

another sales table with Customer, SalesDate and Amout.

I would like to see the first Sales Amount after each customer updates. So For each customer, I need to find the minimum SalesDate greater than the UpdateDate, then sum up Amount on that SalesDate. 

I'm not sure how to write the expression. Should be something like:

sum( {<Min(SalesDate)={"=SalesDate>=UpdateDate"}>} Amount)

Hi,

I have been facing an issue while restarting the Qlik Services, i was able to start QRD and QSD but while starting QRS i got can error stating "The service did not respond to start or control request in a timely fashion" . 

i tried the solution from this link > https://community.qlik.com/t5/Qlik-Sense-Deployment-Management/Qlik-Sense-2-0-1-Cannot-start-services-after-update/td-p/866022  but this didn't work for me.

Can anyone please help me out with this.

PFA screenshot

Thanks in Advance,

PS