QlikView-QlikSense

[cesarbadill8]

Hi, everyone!

This table of receipts is a table made only with expressions and without labels, but it has a peculiarity, that they are ordered vertically, do you have any idea how I could order them like this in Sense?

They are placed like this and I need them vertical.

Thanks a lot.

[RafaelBarrios]

Hi @cesarbadill8 

haven't tried but I guess you can do it using valuelist

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Synthet...

something like 

valuelist(
Measure1,
Measure2,
…,
…,
)

and combined with pick if you need more free to set columns

Pick(Rowno(),
column2_Measure1,
Column2_Measure2,
…,
…,
)

hope this helps.

Best,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 🙂

[cesarbadill8]

It is that the measures are operations carried out by one or more fields, which generates conflict for me, for example one of the values ​​of a field is obtained like this: 

• Count(IF([ID Tipo Refactura] = 'F', [Factura Anterior Refactura]))