Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Re: Export by Dimension

Ralf - What about a more dynamic approach?  Let's say we've only got 3 sites/stores right now, but that we want the script to check for possible values first before assuming it's just '1 through 3'?

You are both widening my knowledge by leaps and bounds...

Not applicable

Re: Export by Dimension

Erich - Your answer was actually right on the money.. I just ignored the syntax error and let it roll, and it created each file just as it was expected to!

That was fantastic, thank you!

MVP
MVP

Export by Dimension

I just made it simple as possible so that's more understandable. It's always easy to complicate things..

Btw. the NoConcatenate is not needed in this case because the table gets dropped. If needed the right syntax is:

tempTable:

NoConcatenate load * resident Table

where site_id = $(vTable);

- Ralf

Highlighted
Not applicable

Export by Dimension

Gotcha - I see your point now also about it being dropped

I'm still fresh eyes when it comes to QV, but this community is so fantastic and helpful!

Thanks again fellas!

Community Browser