QlikView style Transformation in Qlik Sense text file loader

[Oleg_Troyansky]

Hi everyone,

Remember the Transformation feature in QlikView Text File Wizard? The part of the wizard where we could fill in missing data, remove garbage rows, unfold, rotate, etc.? That was very useful for loading challenging spreadsheets, especially those provided by finance departments 😉

I have a couple of questions on that:

1. Do you know if there are any plans to bring this functionality to Qlik Sense? Any Qlikkies who might be reading this - can you please find out?

2. Does anyone have a detailed description of the syntax that is getting generated? I'd love to see a guide that we could use to type similar FILTERS in Qlik Sense, to achieve the same transformations. If you happen to have something like this, kindly share.

Cheers,

Oleg Troyansky

[howdash]

I haven't used QlikView in a while but I know what you're referring to. I haven't seen that dialog in Qlik Sense but if I remember it correctly, all that dialog did was help construct a LOAD script that uses CrossTable function, which is available in Qlik Sense. Here's the link to documentation:

https://help.qlik.com/en-US/sense/May2025/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/...

[howdash]

Actually, I misspoke! The transformation wizard added filters() function(?) to a LOAD that used Remove() function. It looks like the filters() function works in Qlik Sense, but we have to manually type what rows we want to remove. Something like this:

I tried searching for a documentation the filters function, but couldn't find one.

[Oleg_Troyansky]

Hi @howdash !

Exactly right! I'm after these Filters() . Would be nice to have their complete syntax documented somewhere.

Anyone?

Cheers,

Oleg

[marcus_sommer]

I doubt that there is any official documentation of the technically implementation available. I never saw one nor to other inbuilt load-features like crosstable/generic/intervalmatch. I assume that they don't have much special logic/libraries else that they are just a kind of shortcut to normal script-measurements which would to be used to perform them manually.

Nevertheless there exists further a feature-description for the transform-feature with a bit of how-to and why:

File Wizard: Transform | QlikView Help 

Because of the fact the engines from View and Sense are further (nearly) the same I would assume that the transform would further be working - and just the drag'n drop UI is missing. Did you make a test? 

[Oleg_Troyansky]

Hi Marcus,

I tested it years ago, when the two engines got united into one. The syntax worked in Qlik Sense - you just need to know how to formulate it, and the keywords are rather cryptic. Perhaps I should re-test it today. It may not be working anymore. I was looking for a cohesive description of the various FILTERS and conditions. 

Cheers,

Oleg

[marcus_sommer]

With the assumption that this transforming wasn't a complete new development from the scratch else derived from other programming tools/languages I searched for some parts like: filters(...) and RowCdn(...) with Google and Copilot a few rounds but there were no helpful result.

With a bit more efforts in this direction and/or searching within elder resources there might be any useful hint. Another possibility could be to contact some from the earliest Qlik-staff. I could imagine that HIC might be able to give some insights.