Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have small doubt..
I have dimension like
Region
----------
North
south
east
west
so these values I want to display in text box how can I do this? Is there any specific function?
Concat(Distinct Region, ',')
This will give you comma separated values.
Concat(Distinct Region, ',')
This will give you comma separated values.
Nice thank you
And one more thing
I want to load only south,east from that field
I want to load as optimized how can I do ? I don't want to use where condition.?
Try like:
filter:
Load Filter Inline [
Filter
south
east
];
Load
Region
From <qvd path> where exists(Filter, Region);
Drop table filter;
Ohh if I use exists function it is optimized?
Yes, it is still optimized. Read this: qlikview-optimised-qvd-loads
thanks I will go through it
its giving page not displayed
It's an active page. Possibly your network is restricting it. Please check.