Hello,

I am using total 4 fields. One field is for Pivot Dimension and 2 Fields as Columns and 1 field as Measure ( Sum(Sales)).

If I expand one of the column, I will get 7 values as sum(sales) . Is there any way to identify last 3 values and  assign color for last 3 values. Can Someone please advise.

-Karthick.

Hi,

Our business is moving to a new O365 tenant in the coming months  (aligning all child companies under a single parent company) and we are currently authentication users using Azure AD on our current tenant (specific to our company).

What implications / setup requirements will be needed by us to be able to authenticate users on our new tenant when this becomes available?  Also how does it work with existing users, Tenant Admin, Ownerships etc.

We are due to have a test build of our new tenant next week, are we able to have multiple IdP's  active at one time?

I'm not and IT person by any means so if this is going to be a problem then we need to know sooner rather than later so we can engage external support.

Thanks

Hi guys,

I have some data in a copy of a sql database that I'd like to read directly from Qlik Sense. Is it possible?

I know that I can import the SQL data in a SQL environment and then read it with Qlik Sense, but the point is that I want to avoid this step.

For this purpose I've attached a SQL Server sample database of bikes, in case any of you know how to do it, could show the community how is made the loading script

Kind regards, Marcel.

Hi, I have a pivot table that looks like the one below in Qlik Sense.

'Where first seen' and 'Date' are dimensions. The 'T/S', 'T/C', 'C', 'D/C' and 'D/S' are measured values that use the count function. I would like to show only the last 5 days of data in the table without the user having to touch anything.

Only loading 5 days of data in the script isn't an option as we have multiple pivot tables showing different lengths of time on the same sheet (eg. 5 days of data, 10 days of data, 30 days of data). 

Can anyone please help with this ? Thanks a lot! 

Hi,

Is it possible to hide the sheets in app in qliksense.

scenario: I have 6 sheets under app , in every sheet i created the six buttons on the top for navigation.so now i can see the 6 sheets in the app . is it possible to hide the sheets by keeping only one sheet in the app. 

if we place only one sheet under app so  by clicking on the main sheet , a user can go through all sheets with the buttons inside sheet. my problem is that i want to hide remaining sheets , i want to see only one sheet under the app is that possible in qliksense.

Hi,

I have been struggling to make this expression work. I am trying to get Prior YTD count of distinct PatientIDs for each of these 3 categories by only picking the category of Patient with Max Discharge DT.

Dummy DataSet:

PatientID     Category    DischargeDT

Tom                 AZ                   1/31/2021

Jerry               BZ                   1/21/2021

Jerry               CZ                    2/8/2021

Expected Object result:

1. Count(distinct Patient ID) where Category AZ = 1

2. Count(distinct Patient ID) where Category BZ = 0

3. Count(distinct Patient ID) where Category CZ = 1

The expression im using currently  for one of the category is 

count({$<DischargeDT = {"=$(=Date(max(DischargeDT), 'YYYY-MM-DD'))"} , Category={"BZ"},

PeriodType={"YTD"},AsOfPeriod={"202102"}>}distinct PatientID)

which Im expecting to give me an output of 0 instead it gives me 1 for all these categories. I dont care about BZ, I only want to count the category of Patient with most recent Discharge DT.

Please let me know what Im doing wrong in the expression.

Thanks