Deselect content in QlikView

[Anonymous]

Hi,

I want to deselect something in my QlikView report. Lets say i want to deselect a row if column 1 = "something" and column 3 = "something 2" and if column 7(that is a customer id) starts with "9" or starts with "4". is that possible?

[krishnacbe]

Hi,

Share some sample data and expected output that will help us to understand the requirement.

[Digvijay_Singh]

Yes, it is possible.

[marcus_sommer]

For me it sounds that you want to overwrite and/or to ignore certain selections - this could be achieved with: A Primer on Set Analysis.

- Marcus

[Anonymous]

I can make my question a bit easier: I get one report and i want to exclude some of the rows. If this was an database, i would hav written:

SELECT * FROM table

WHERE (column1 <> "asd" and column2 <> "24" and  column3 <> "12345678")

Im not the owner of the QV-document, so i can't write a code like this in the document-editor(edit script). But i can create objects like buttons, listbox etc. could i maybe write a code like this as an expression in a a button, or a listbox or something?

[krishnacbe]

Hi,

If you wan to show something in Chart/List box you can exclude the rows by writing IF condition or Set Analysis Expression.

[marcus_sommer]

An expression with an included set analysis filter could be look like:

sum({< column1 -= {'asd'}, column2 -= {24}, column3 -= {12345678}>} value)

- Marcus

[Anil_Babu_Samineni]

Marcus, But he is mention

Select * From

Do we get all from requirement

How About This? Please correct me if i am wrong

sum({< column1 -= {'asd'}, column2 -= {24}, column3 -= {12345678}>} TOTAL value)

[marcus_sommer]

It will be depending on if the filtered dataset should be evaluated against any dimensions or not if a TOTAL statement will be needed.

- Marcus