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.
Solved! Go to Solution.
@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 %
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: