topic Re: Deselect content in QlikView in QlikView

Deselect content in QlikView

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Deselect content in QlikView

krishnacbe — Thu, 15 Sep 2016 17:35:00 GMT

Hi,

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

Re: Deselect content in QlikView

Digvijay_Singh — Thu, 15 Sep 2016 18:43:40 GMT

Yes, it is possible.

Re: Deselect content in QlikView

marcus_sommer — Fri, 16 Sep 2016 07:38:48 GMT

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

Re: Deselect content in QlikView

Anonymous — Fri, 16 Sep 2016 12:41:36 GMT

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?

Re: Deselect content in QlikView

krishnacbe — Fri, 16 Sep 2016 16:42:17 GMT

Hi,

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

Re: Deselect content in QlikView

marcus_sommer — Fri, 16 Sep 2016 17:09:31 GMT

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

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

- Marcus

Re: Deselect content in QlikView

Anil_Babu_Samineni — Fri, 16 Sep 2016 17:24:03 GMT

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)

Re: Deselect content in QlikView

marcus_sommer — Sat, 17 Sep 2016 10:35:50 GMT

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