Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
For following example:
Load * Inline [Account_Type
'20.001',
'20.00100',
'20.0010'];
How to insure qlikview shows up three values in List box or aggregated pivot.
What we are seeing is
result of above example is :
20.001
Therefore in list box it will display 1 row. If we try to aggregate any data, rather than 3 different account types, it aggregates to 1 row.
Please advise.
Regards
Ravi
Hi
Try like this
LOAD
...
Text(Account_type) as Account_type;
SQL SELECT
Account_type,
...
FROM DBTABLE;
Thanks everyone.
Have to say this was not straight forward and not straight way to handle it. Most of standard tools do keep in mind data type while selecting.
Thanks
Regards
Ravi
Agreed that this might not be intuitive.
Please check these blog posts:
http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/13/dual
http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/07/automatic-number-interpretation