hi i'm new to qlik sense,

i have a doubt in qlik sense

description             portfolio1           portfolio2            portfolio3             portfolio4         

expenses                   2000                           100                         500                           0

revenue                     1000                        1500                         2500                        100

Now, i want a third row that row should be divided by expenses/revenue with percentage

so if anyone knows please let me know what is the expression and where i can create the expression i mean field ASAP

Good morning Experts,

I am facing an unprecedented situation in which a syn key is generated after the data has completed loading from the data load editor. The syn key arises from a table called 'QueryResult', which I am very sure I did not code for in the data load editor (and I verified this through the Search function in the data load editor). The conflicting fields in this QueryResult table with my main fact table are from a table which I had specifically dropped in the script, but somehow reappears and renamed as this 'QueryResult' table.

Anybody faced a similar situation or know how to simply remove this table (from nowhere)?

Thank you very much in advance,

Jason

Hello,

I have installed Qlik Sense Enterprise on-premise in the customer environment. The customer wants me to generate CSR from Qlik sense but I don't know the steps on how to create the CSR from Qlik Sense. I tried looking at the community but unfortunately, the information is archived.

I will appreciate it if anyone can share the steps to generate CSR from Qlik Sense.

Thanks and Regards
Vaibhav 

I wanted to connect the Qliksense with the Nprinting server. So when i try to export the certificates from QMC, it throws the error

" the export of the certificates failed"

Used the root admin account to login in QMC

Attached the screenshot of the error

Hey,

I have issue with total row in pivot table.

All of my value collumns are from measures.

Total work mainly with one row or simple filter. Which is somewhat useless.

Any help? I use only one dimension.

Hi,

my data looks like,

in this Modes 8.0AB and 35.0AB showing KD column as KD and nKD will replace these values to KD. like KDnew column as my output. i am trying if condition not working help me thanks.

Dear Supporter,

We build the qliksense in Alicloud vm , but the db connectors not shown there,  it's work for built in google cloud platform vm, may I get your suggestion , many thanks.

We want to clear these db connector is  installed in the qliksense exe file or other places ? Many thanks.

Hello Experts,

We have deployed Qlik sense in the customer environment and the customer now wants to add a header through which they can log i.e. in instead of localhost/hub or localhost/QMC they want  customheader/hub or customheader/qmc

Can you please provide steps on how to add a custom header to Qlik Sense?

Thanks and Regards

Vaibhav

Hi,  

Tried to built a dashboard for retail and allow store user to select 2 different time periods with some calculation to compare the sales result at product level, customer level.  Usually store people would like to look at the product and customer variance during different period especially to compare the sale uplift in different promotion period.

We have a daily raw data sales format like following (a simply version).  And it is easily enough for me to bring in branch, product hierarchy table into Qlik as well.

Dashboard looks like the following:
Allow user to select Primary date range period that I've applied alternative group called "Primary" into the filter.  And done the same for Comp Period as "Comparable" group.

We're trying to do an "apple to apple comparison" by selecting different time period.   The table shows sales various by product.  (I will need to create the same table for Customer)

Sales Primary = sum({Primary}Sales)
Sales Comp = sum({Comparable}Sales)
will return us the sales within the selected periods but won't drill down if select any dimension in the filter.

So I learnt:
Sales Primary = sum({Primary<[Branch]=$::[Branch],
                                                                 [Trade Type]=$::[Trade Type]
                                                                 [Category]=$::[Category]
                                                                 [Product ID]=$::[Product ID]>}Sales)
Ps:  Same applied into Comparable Sales as well:

I am still bit struggle to understand $ vs P.  but it looks OK so far, my question is

1.  My dimensions are getting bigger (adding in 15 more dimensions such as trade account num, customer, sales channel.  Instead to adding all the dimension one by one within this formula (sometime may missed), is there any way we can included all dimension?

2.  Hope if anyone can help me to understand what is [Branch]=$::[Branch] mean?  :: and what is the different between $ vs P.

3.  If we build a chart, we can use alternative dimension to swap the dimension across with the same measurement.  Wonder if any easy way for table?  The only option I've got is to create all the require dimension tables within a container so user can change across.  Is anyone have any better suggestion?

Many Thanks

In a CDC load environment, how do you maintain an attribute value that represents the maximum or minimum value over a set of records? 

For example, if I have an order with three items, I want to create an attribute called MaxItemRequestDate where this value is the max Request date among the three items.

I have tried using a windowing function on both the entity and in the mapping. But, looking at the task list scripts SQL, it looks as if in the CDC process the function will only be performed over the delta rows in the TSTG "staging" table, and not the entire row set like it would be in a full load.

Can I have the best of both worlds ?

Thanks!