Looks like Cross table

priyarane — Thu, 09 Mar 2017 13:18:36 GMT

Hi Community,

I have requirement excel and I need to use those columns in my select query to pick data from oracl database.

As per the excel - no need to bring columns if 'n/a', if yes need to use them in select and group by statement, if E then we have to use like sum(Expr1) as Expr1.

My plan to use the excel and bring those columns in the variable(one is for select and second one is for group by statement) as per the requirement and that variable I will use in the select statement while pick the data from database.

I have tried little bit still not get exactly what I want, can some one share your ideas.

- Priya

topic Looks like Cross table in QlikView

Looks like Cross table