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.
