Hi,sales

I have ranked my stores by sum(sales) by the expression: rank(sum(sales).

I want to create a KPI that will indicate my rank store based on the name store.
for example:

If my store las Vages is ranked as 13. I want my KPI to show 13 at any time I choose this specific store.
if I just put this expression rank(sum(sales) I will always get 1 because I am filtered in this specific store..

how do I get 13 for example for the choose store? 

Hi Guys,

I need a help!

above snap I need to  remove the time format.I have applied logic it's working but few places time has visible below snap.

I am using  this logic below.kindly help me.

Replace(Replace(Replace( [DEPDATE &TIME],SubField( TextBetween( [DEPDATE &TIME], '-','/'),'-',3),''),'-/','/'),Right(Replace(Replace( [DEPDATE &TIME],SubField( TextBetween( trim([DEPDATE &TIME]), '-','/'),'-',3),''),'-/','/'),7),'') as [DEPDATE &TIME1]

Thanks,

Nagaraj

Hi everyone,
I have a database which is connected to Qlik Sense. There is a record in the database which is not loaded in Qlik Sense. There is a QVD Generator between database and Qlik Sense. The problem exists only for one record and other records are loaded without any problem. Has somebody any idea to solve this issue?

There's a date field that has some inflated values like 8/15/57263 and similarly there are ~1000+ records. Along with these inflated values there's also values coming in format of MM/DD/YYYY. When taken a list box and exported this field to excel the values with 8/15/57263 comes as ########### and when hover over, it says 'Dates and times that are negative and too large are shown as ####### . On the table viewer this date field is integer. I want to change these inflated values to date format of 'MM/DD/YYYY' and also keep the other values too in the field. Any help is appreciated.

Hi all,

We are planning to upgrade to qlik sense enterprise edition of November 2023 ,can anyone please confirm whether this upgrade will works fine on postgres version of 12.5 or upgrade to the 14.8 is required?

Regards,

Raju

Hello,

I'm new to Qlik Cloud Integration. 

Creating the Onboard from Onprem to target snowflake.

While running the task, it is keep on going to Queued and not completing with data load to target system.

Only metadata is getting created in snowflake.

I dont have windows configuration access from my side to check the memory or CPU. If anything to verify in Qlik cloud or any other workaround .Please suggest.

Hello to all
I'm a bit new to Qlik, please forgive me!
I recently got hired at a large company that has a lot of QlikView dashboards.
It has been decided to consolidate all the organization's dashboards together with the dashboards written with other software on one portal.
Therefore, we intend to do this with the help of C#. I have made a decision for Power BI and SSRS and crystal report and ... , but I don't know how to communicate with QlikView so that the login message is not displayed when loading the dashboard. Qlik dashboards uses Active Directory to login and each user must login if he or she wants to see dashboards
Please guide me.
Thanks.

Hello everyone,

 At the Webinar  - [Webinar] Do More with Qlik - Tabular Reporting Pt.2

Nprinting Saas readiness app was mentionned.

Where to download it ?

Thanks

We are migrating from QlikView to Qlik Sense in SaaS. I would like to set similar triggers for  specific dimensions when the report first opens. How do I do this?