Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

brabbi1989
New Contributor

Build the Pivot Table. Incorrect Data

Hi. I need you help. Situation: Client wants some the general report using pivot table for three differents customers and customers apps. 

So, I wrote the SQL Stored procedure with all the data for three customers and categories. Data from SQL is correct.

In Qlik Sense I download all the data into one table, after this for customers and customers app I download small table. Qlik builds synt key, which include four columns. When I download data for 1 customer - everything is ok. When I download for 2 customers - the same fields displays in pivot into others format(format in qlik is auto, I prepared and formatted data in SQL, in Qlik data transfers in format).

 

Why is it happens? Or maybe you know the best idea how I can build it.

Thanks.

 

1 Solution

Accepted Solutions
Highlighted
miskinmaz
Contributor II

Re: Build the Pivot Table. Incorrect Data

so you can use, the expression at the script level like
num(sales,'$ #00.00') or num(sales,'00.00 %')
You need to use the alt function to get the result likewise. You can attach the sample app
10 Replies
miskinmaz
Contributor II

Re: Build the Pivot Table. Incorrect Data

What exactly is the format. Qlik can manage to bring the data into one format either at the script level or expression editor. You can refer the date# or num# function
brabbi1989
New Contributor

Re: Build the Pivot Table. Incorrect Data

@miskinmaz I convert all to nvarchar type, cause client in one column wants to see money and percent type.

miskinmaz
Contributor II

Re: Build the Pivot Table. Incorrect Data

Can you give some example about how it is stored in sql and how it should be displayed
brabbi1989
New Contributor

Re: Build the Pivot Table. Incorrect Data

@miskinmaz In SQL it stored as float(123.765), in Qlik it shoul be as $123.765 or percent - 85%. So I transform in Nvarchar and concate with $ or %

miskinmaz
Contributor II

Re: Build the Pivot Table. Incorrect Data

No need to change the format at the sql side. Get  the data in plain numbers from the sql and in qlik under expression tab you can manage the format:

format.JPG

brabbi1989
New Contributor

Re: Build the Pivot Table. Incorrect Data

@miskinmaz 

   http://prntscr.com/ng72fh

Thanks. What should I do in this case, which on the screen?

miskinmaz
Contributor II

Re: Build the Pivot Table. Incorrect Data

Did you try to change the money expression in the expression tab
brabbi1989
New Contributor

Re: Build the Pivot Table. Incorrect Data

@miskinmaz  Yes, but in one column client wants to have the money and percent value. And I don't know how do it in qlik sense.

Highlighted
miskinmaz
Contributor II

Re: Build the Pivot Table. Incorrect Data

so you can use, the expression at the script level like
num(sales,'$ #00.00') or num(sales,'00.00 %')
You need to use the alt function to get the result likewise. You can attach the sample app