Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For Example : ( Male or Female) If I select male only the data corresponding to that should be filtered. Likewise I want to filter my charts by using this 2 columns ( Polat or Podat). There is one more thing this two columns have date data's and I don't want them. Please any one help me to fix this issue. I don't know how to do this with qlikview. I am a new one to this tool. Thank you
I don't want this type.
I want like this
Instead of "N" i want "Polat" and for "Y" i want " Podat".
IS specials as calculated field or just a field coming from your data source tables. May be you can create a flag like in your script
LOAD .....,
Pick(Specials, 'Polat', 'Podat') AS SpecialFlag
FROM yoursourcsTable;
OR
LOAD ....,
IF(Specials = 'N', 'Polat', 'Podat') AS SpecialFlag
FROM yoursourceTable;
If you specials is a calculated field let me know what that expression is in your script.
create new column in your load script, something like
if(isnull(Podat),'Polat','Podat') as YourNewFieldName
then you can drop the other 2 also in your script with
Drop Fields Polat,Podat;