Hi,

i upgraded from 3.1 SR1 to june version of Qliksense. After Upgradation it in Load Editor when i load the app, App not get updated and throwing error "Access Denied"

I am the root Admin. Please help me on this and why this error is happening.

Hello, 

I am attempting to force a vizlib filter in my  dashboard to default to a certain value. I have two columns, one of which shows all the months YTD, and one of which just shows the latest month. I would like table to be filtered to show only those rows where Month = Latest_Month upon opening the sheet or clearing any existing Month filter. 

Any help with this would be much appreciated.

Hi all.

Please help me with the expressions in my bar chart. There is one already here but I do not know what it means?

count({<[Subject] -= {"*Missing*file*"},
[exclude flag] = {0}>}[Subject])

Basically in my chart I need the date as today date or latests date , this is d-1.

I need to see the number of dl name , sent by, received time, and subject.

I also need help excluding things from my script like certain email distributions and subjects. So that it is not in my charts, unless I  can do this in my charts.

Hi all.

I desperetly need help! 

I need to set a trigger so that all of the data on my sheets open for today -1. It is opening all the data but not today -1. The same goes for in the charts I need data to reflect today -1 . i tried to add it as a dimension but no luck.

Hello everyone,

I am having two tables below. 

Table: A

Table B:

I need to left join Table B to Table A based on multiple conditions.

Condition 1: Left join if (Table A Buy Ccy = Table B Buy Ccy and Table A Buy Amount = Table B Buy Amount and Table A Sell Ccy = Table B Sell Ccy  and Table A Sell Amount = Table B Sell Amount) or (Table A Buy Ccy = Table B Sell Ccy and Table A Buy Amount = Table B Sell Amount and Table A Sell Ccy = Table B Buy Ccy  and Table A Sell Amount = Table B Buy Amount)

As Brach sell and buy with the Customer but the Table B data is random. So need to compare both the combination of Ccy and Amount between two tables regardless sell or buy.

Condition 2: A check is needed here. If there are more than one Customer in Table B match with a Branch in the Table A, leave Customer blank in the joined table. For example, both Customer CC and DD match Branch C based on the Condition 1, leave the customer blank.

The final table should be like:

Could you please provide the possible solution for this scenario?

Thanks in advance. 

Kind Regards,

Riva 

I have seen other users ask about creating clickable cells and read that it is on the roadmap, or was in 2016, what is the status on this? Can I make my cells clickable and able to update the sheet? I see something quite close with the heat maps but can't seem to do it with the pivot table. 

If not what are some work arounds? We are moving from SSRS which has this functionality so it looks bad to the users that the more modern solution doesn't seem to be able to handle clickable cells.

Best,

Jacob

Hi I have gone through lots of community discussion to find solution to show partial sum in pivot table. All says use aggr function, I am already using that.

Can someone guide what I am missing here 

My expression is:-

I am trying to get the Single Denom field to show 12 is Agenda Year is NOT 2019 and 8 if it is 2019 for the count of months to calculate the average. It works some of the time but not all of the time. Any idea why? TIA!

=if(year(today())=year(if(GOV_DECISION_BODY_SUB=PRIMARY_DECISION_BODY,date#(yearstart(PRIMARY_DECISION_AGENDA_DATE)),
if(GOV_DECISION_BODY_SUB=PRIMARY_DECISION_COMMITTEE_CAT,date#(yearstart(PRIMARY_DECISION_AGENDA_DATE)),
if(GOV_DECISION_BODY_SUB=SECONDARY_DECISION_BODY,date#(yearstart(SECONDARY_DECISION_AGENDA_DATE)),
if(GOV_DECISION_BODY_SUB=SECONDARY_DECISION_COMMITTEE_CAT,date#(yearstart(SECONDARY_DECISION_AGENDA_DATE)),
if(GOV_DECISION_BODY_SUB=THIRD_DECISION_BODY,date#(yearstart(THIRD_DECISION_AGENDA_DATE)),
if(GOV_DECISION_BODY_SUB=THIRD_DECISION_COMMITTEE_CAT,date#(yearstart(THIRD_DECISION_AGENDA_DATE)),
if(GOV_DECISION_BODY_SUB=FOURTH_DECISION_BODY,date#(yearstart(FOURTH_DECISION_AGENDA_DATE)),
if(GOV_DECISION_BODY_SUB=FOURTH_DECISION_COMMITTEE_CAT,date#(yearstart(FOURTH_DECISION_AGENDA_DATE)),
if(GOV_DECISION_BODY_SUB=FIFTH_DECISION_BODY,date#(yearstart(FIFTH_DECISION_AGENDA_DATE)),
if(GOV_DECISION_BODY_SUB=FIFTH_DECISION_COMMITTEE_CAT,date#(yearstart(FIFTH_DECISION_AGENDA_DATE)),
if(GOV_DECISION_BODY_SUB=SIXTH_DECISION_BODY,date#(yearstart(SIXTH_DECISION_AGENDA_DATE)),
if(GOV_DECISION_BODY_SUB=SIXTH_DECISION_COMMITTEE_CAT,date#(yearstart(SIXTH_DECISION_AGENDA_DATE))))))))))))))),num(Month(today())),12)

Hi, I am trying to get a color gradient on my Click column.

I have the color gradient anything between -100%  and 100% however, anything greater or less than that range I am not able to get a color associated to it. 

This is the formula i am currently using.

if(match(only({1}Period),'WoW')>0,ColorMix2((sum({$<IsBrand=,Program=,Engine=,Device=,Category=,Week={"$(=$(vLastFullWeek))"},SharedDMA=>}Click)
/sum({$<WeekName=, Year=,Week={"$(=$(vPriorLastFullWeek))"},IsBrand=,Program=,Engine=,Device=,Category=,SharedDMA=>}Click)-1),Lightred(),Lightgreen(),white()),
if(match(only({1}Period),'YoY')>0,ColorMix2((sum({$<WeekName=, Year=,Week={"$(=$(vLastFullWeek))"},IsBrand=,Program=,Engine=,Device=,Category=,SharedDMA=>}Click)
/sum({$<WeekName=, Year=,Week={"$(=$(vLastFullWeekPriorYear))"},IsBrand=,Program=,Engine=,Device=,Category=,SharedDMA=>}Click)-1),lightred(),lightgreen(),white())))

I also attached a picture for reference of the output of my table. 

Can someone please help?

I have a transactions data. I want to create a table having date range with account number and total amount of transactions.

For example:

Data:

Date    account Number     amount

11-July-19  XYZ                     40

11-July-19 ABC                      20

12-July-19 XYZ                        60

13July-19   XYZ                       20

13-July-19 ABC                    100

14-July-19 ABC                      50

16 July 2019 ABC                 40

and so on...

Desired Output for every 5 days interval (Can use a pivot table but unable to get the results):

Date                         Account Number          Amount

11-15 July 2019           ABC                           120

11-15 July 2019           XYZ                           120

12-16 July 2019          ABC                             140