Build the Pivot Table. Incorrect Data

[brabbi1989]

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.

[miskinmaz]

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]

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

[miskinmaz]

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

[brabbi1989]

@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]

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:

[brabbi1989]

@miskinmaz 

   http://prntscr.com/ng72fh

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

[miskinmaz]

Did you try to change the money expression in the expression tab

[brabbi1989]

@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.

[miskinmaz · Accepted solution]

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